droptableifexists user_info;droptableifexists email_info;createtable user_info(
id intnotnullauto_incrementprimarykey,
name varchar(30),
email varchar(50));insertinto user_info(id, name, email)values(1,'柳峰','liufeng@qq.com');insertinto user_info(id, name, email)values(2,'张三','zhangsan@qq.com');createtable email_info(
id intnotnullauto_incrementprimarykey,
email varchar(50),
content text,
send_time datetime);delimiter//createprocedure sendEmail(in user_id int,in content text)beginset@user_email=(select email from user_info where id=user_id);insertinto email_info(email,content,send_time)values(@user_email,content,now());end;//delimiter;call sendEmail(2,'delimiter ;要有空格');select*from email_info;
存储过程实现1+2+3+…+n
delimiter//createprocedure t_02(in n int,out res int)begindeclare i intdefault1;declare sum intdefault0;while i<=n doset sum=sum+i;set i=i+1;endwhile;set res=sum;end;//delimiter;call t_02(500,@res);select@res;