SQL – 两个SQL
本人低玩,见到如此的SQL必会惊讶不已,记录一下。
LEFT就是截取某个字段、从左数第N个字符,GROUP BY它之后就能实现这种按小时统计的效果,同理,也可实现按分、按秒、按日、按月、按年统计。
1 |
SELECT LEFT(table_submit_time,13) AS hours,COUNT(*) FROM table_user WHERE table_submit_time LIKE '2011-09-08%' GROUP BY hours; |
INTO OUTFILE这个就是把查询到的结果输出到指定的文件中
1 |
SELECT table_name FROM table_user WHERE status='YES' INTO OUTFILE '/data/apache/temp/export.txt'; |