MySQL SQL语句随笔
MySQL SQL语句随笔, 主要是以前用的比较少但是又很有用的一些,例如: UNIX_TIMESTAMP,SUM,DISTINCT,SUBSTRING,DATE_ADD,ON DUPLICATE KEY,CONVERT_TZ等。
[php]"SELECT DISTINCT SUBSTRING(timestamp,1,10) start, DATE_ADD(SUBSTRING(timestamp,1,10), INTERVAL 1 DAY) end FROM `$hits` WHERE timestamp < FROM_UNIXTIME('$older_than') ORDER BY `id`";
"INSERT INTO `$archive_sites` (`range_id`,`site_... CONVERT_TZ, DATE_ADD, DISTINCT, MySQL, ON DUPLICATE KEY, SQL语句, SUBSTRING, SUM, UNIX_TIMESTAMP阅读全文