1. 存储过程
mysql> delimiter // 定义//作为结束标记符号
mysql> create procedure spinsertuserinfo(
-> puserid int,pusername varchar(10),puserbirthday date)
-> begin
-> insert into myuserinfo values(puserid,pusername,puserbirthday);
-> end;
-> //
Query OK, 0 rows affected (0.00 sec)
mysql> show procedure stattus like 'spinsertuserinfo'; --查询该存储过程
mysql> call spinsertuserinfo(2,'wagnwu',current_date); --调用该存储过程,crrent_date是当前日期