mysql
delimiter $$                  use mysql$$drop procedure if exists demo$$create procedure demo(_id int, _content varchar(64))    begin               set @id = _id; set @content = _content;                                                                                       prepare stmt from insert into blog (id, content) values(?, ?); execute stmt using @id, @content; deallocate prepare stmt;end$$delimiter ;delimiter $$
如果改写成如下就会报错：
delimiter $$use mysql$$drop procedure if exists demo$$create procedure demo(_id int, _content varchar(64)) begin -- set @id = _id; -- set @content = _content; prepare stmt from insert into blog (id, content) values(?, ?); execute stmt using _id, _content; deallocate prepare stmt;end$$delimiter ;
错误代码： 1064you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near '_id, _content; deallocate prepare stmt;end' at line 7