CREATE TABLE `proc_test` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT, #ID,自动增长
`username` varchar(20) NOT NULL, #用户名
`password` varchar(20) NOT NULL, #密码
PRIMARY KEY (`id`) #主键
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8; #设置表引擎和字符集
create procedure mytest(in name varchar(20),in pwd varchar(20))#定义传入的参数
begininsert into proc_test(username,password) values(name,pwd);
#把传进来的参数name和pwd插入表中,别忘记分号
end; #注意这个分号别忘记了
执行存储过程时会报错:
ERROR 1064 (42000):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 'END';