1、排序关键字 order by
asc升序排序;desc降序排序
示例1:
从table_name中获取column_name值最大的size个数据。
select column_name from table_name order by column_name desc limit size.
示例2:
从table B中获取column_name最大的size个记录,并插入到table A。
insert into table_nameA select * from table_nameB order by column_name desc limit size
2、清空表的内容,但是不改变表结构
delete from table_name
删除部分数据
delete from table_name where param_id=''
示例1:
这里有一句很实用经典的,删除部分数据,保留最新的20条。
delete from infocache where patient_id not in (select patient_id from infocache order by last_time desc limit 20)