MySql学习笔记

1.查询多少天以前的数据

select * from db_clans where  DATE(created) <= DATE(DATE_SUB(NOW(),INTERVAL 30 day))

 

 select * from 表名 where  DATE(根据的字段名) <= DATE(DATE_SUB(NOW(),INTERVAL 多少天前 day))

 

select 字段名 from 表名 where 字段名!='' order by 主键 desc limit 1;

select violations from dengluqi where violations !='' order by steamid desc limit 1;