mysql:查询当前数据的所在行号2022-02-05 03:13:38select @rownum:=@rownum+1 rownum, sys_organ.* from (select @rownum:=0) r, sys_organ order by sys_id desc; 更新某一字段等于所在行号: set @num = 0; update sys_organ set organ_num = (@num := @num + 1); mysql:查询当前数据的所在行号上一篇:[deepin]解决:处理软件包 mysql-server (--configure)时出错的问题下一篇:26_ mysql数据操作语言:DELETE语句