需求:在一个表中新增字段,然后让其值自增
set @rownum=0;
update tb_student
SET stu_virtual_id = (
select @rownum := @rownum +1 as nid)
where stu_virtual_id is null;
需求:在一个表中新增字段,然后让其值自增
set @rownum=0;
update tb_student
SET stu_virtual_id = (
select @rownum := @rownum +1 as nid)
where stu_virtual_id is null;