1、查找某个表id的最大值
select max(id) from table1
2、倒序排,显示前5个
SELECT * from tab1 ORDER BY hits_num DESC LIMIT 5
3、更新某列字段值
UPDATE tab1 SET name = 1 WHERE …
1、查找某个表id的最大值
select max(id) from table1
2、倒序排,显示前5个
SELECT * from tab1 ORDER BY hits_num DESC LIMIT 5
3、更新某列字段值
UPDATE tab1 SET name = 1 WHERE …