Mysql行号

使用MySQL查出的结果显示行号

SELECT @rowno:=@rowno+1 as rowno,r.* from t_article r,(select @rowno:=0) t

给MySQL添加行号

SET @mycnt = 0; 
UPDATE datamanagement
SET rownum=(@mycnt := @mycnt + 1)
WHERE id>38
ORDER BY createdtime;

 查询MYSQL表字段最大值的方法

select max(id) from dbname

 

转载于:https://www.cnblogs.com/xbblogs/p/5713755.html