实现update set字段的递增
set @rownum=102400000;
update t_file_metadata SET id = ( select @rownum := @rownum +1 as nid)
WHERE origin_name like '1M-pdf%';
效果如下:
实现update set字段的递增
set @rownum=102400000;
update t_file_metadata SET id = ( select @rownum := @rownum +1 as nid)
WHERE origin_name like '1M-pdf%';
效果如下: