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
);
@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
);
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 ;
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 ;
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
还是有错误!
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还是有错误