由于数据库扩展,db1_user中,将增加一个字段mobile,如果用户名为手机号码,则将mobile的值为用户名,否则为空.
create procedure mobile()
begin
declare temName int default 0;
declare username varchar(32) character set utf8;
declare uid int(11);
declare cur cursor for select id,mobile from db1_user order by (id) asc;
declare continue handler for not found set temName=1;
open cur;
myloop:loop
fetch cur into uid,username;
if temName=1 then
leave myloop;
end if;
//手机号为13,15,18开头的11位数字
if username regexp '^[1][358][0-9]{9}$' then
update db1_user set mobile=username where id=uid;
else
update db1_user set mobile='' where id=uid;
end if;
create procedure mobile()
begin
declare temName int default 0;
declare username varchar(32) character set utf8;
declare uid int(11);
declare cur cursor for select id,mobile from db1_user order by (id) asc;
declare continue handler for not found set temName=1;
open cur;
myloop:loop
fetch cur into uid,username;
if temName=1 then
leave myloop;
end if;
//手机号为13,15,18开头的11位数字
if username regexp '^[1][358][0-9]{9}$' then
update db1_user set mobile=username where id=uid;
else
update db1_user set mobile='' where id=uid;
end if;