创造mysql存储过程,调用 及删除

//创建表create table test (    aid int(10) primary key auto_increment ,    nickname char(20),    addtime int(11)    )//查看表结构 show columns from test;//设置msql  命令结束符，将默认的;更改为$
\d $
//存储过程create procedure del_test(inout n char(20) charset utf8)begin    delete from test where nickname=n;    end$//调用存储过程set @name = '张三'$call del_test(@name)$