数据库流水号递增

set @rownum=0;
update t_asset_vuln_lib SET code =  CONCAT('VULN' ,SUBSTR(CONCAT('00000',(select @rownum := @rownum +1 )),-3),DATE_FORMAT(discovery_time,'%Y%m%d%h%m%s'));