//创建表

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)$