create PROCEDURE insert_address
(
in p_name varchar(30),
in p_uid int(20),
in p_address varchar(30),
in p_mobile varchar(30),
in p_def int(2)
)
BEGIN
– 判断用户选择的是否是默认值
if p_def=1 then
update t_address set def = 0 where uid = p_uid and def=1;
end if;
insert into t_address(name,uid,address,mobile,def) VALUES(p_name,p_uid,p_address,p_mobile,p_def);
end;