在MYSQL数据库中创建存储过程出错,应该是什么格式？

[向大牛学习人工智能]

use jspdev;

create procedure demo_procedure(
@inparam1 varchar(20),
@inparam2 int,
@inparam3 varchar(20),
@inparam4 varchar(50),
@inparam5 datetime,
@inparam6 varchar(100)
)
as insert into contact(userName,mobile,phone,mail,lastcontact,mem) values
(
@inparam1,
@inparam2,
@inparam3,
@inparam4,
@inparam5,
@inparam6
);

[CHRL]

use jspdev;

DROP PROCEDURE IF EXISTS `cesmis`.`BOMTREE` $$
CREATE DEFINER=`localhost`@`%` PROCEDURE `demo_procedure`(
inparam1 varchar(20),
inparam2 int,
inparam3 varchar(20),
inparam4 varchar(50),
inparam5 datetime,
inparam6 varchar(100))
BEGIN
insert into contact(userName,mobile,phone,mail,lastcontact,mem) values
(
inparam1,
inparam2,
inparam3,
inparam4,
inparam5,
inparam6
);

END $$

DELIMITER ;

[小灯数据-脚本小王子]

use jspdev;
drop procedure if exists demo_procedure;
delimiter $$
create procedure demo_procedure(
@inparam1 varchar(20),
@inparam2 int,
@inparam3 varchar(20),
@inparam4 varchar(50),
@inparam5 datetime,
@inparam6 varchar(100)
)
begin
insert into contact(userName,mobile,phone,mail,lastcontact,mem) values
(
@inparam1,
@inparam2,
@inparam3,
@inparam4,
@inparam5,
@inparam6
);
end $$
delimiter ;

[向大牛学习人工智能]

-> end $$
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '@inpa
ram1 varchar(20),
@inparam2 int,
@inparam3 varchar(20),
@inparam4 varcha' at line 2


还是有错误！

[向大牛学习人工智能]

-> end $$
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '@inpa
ram1 varchar(20),
@inparam2 int,
@inparam3 varchar(20),
@inparam4 varcha' at line 2

还是有错误