SQL - 两个SQL | Tech && Test

本人低玩，见到如此的SQL必会惊讶不已，记录一下。

LEFT就是截取某个字段、从左数第N个字符，GROUP BY它之后就能实现这种按小时统计的效果，同理，也可实现按分、按秒、按日、按月、按年统计。

SELECT LEFT(table_submit_time,13) AS hours,COUNT(*) FROM table_user WHERE table_submit_time LIKE '2011-09-08%' GROUP BY hours;

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这个就是把查询到的结果输出到指定的文件中

SELECT table_name FROM table_user WHERE status='YES' INTO OUTFILE '/data/apache/temp/export.txt';

1	SELECT table_name FROM table_user WHERE status='YES' INTO OUTFILE '/data/apache/temp/export.txt';

分享到：

SQL – 两个SQL