![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
cymlancy
http://item.taobao.com/item.htm?id=38986813605
展开
-
Oracle分页查询语句(一)
Oracle的分页查询语句基本上可以按照本文给出的格式来进行套用。分页查询格式:SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM )WHERE RN >= 21其中最内层的查询SELECT * FROM TABLE_NAME表示不进行翻页原创 2012-07-12 16:57:22 · 458 阅读 · 0 评论 -
关于时间查询
select * from taskselect * from user_taskselect * from user_account where name='关维康'--MySql在固定的时间段select * from pk_invite where created_at >= unix_timestamp("2011-05-10 00:00:00")*1000 and cre原创 2011-05-10 16:35:00 · 741 阅读 · 0 评论 -
sql字段切分
#SELECT substring_index(coordinate,',', 1), substring_index(coordinate,',', -1) FROM tmp a LEFT JOIN table b on a.uid = b.uid WHERE;UPDATE tmp a LEFT JOIN table b on a.uid = b.uid SET b.lgt = su原创 2017-06-08 12:01:00 · 1494 阅读 · 0 评论 -
判断mysql日期等于昨天
SELECT trunkname AS trunkname FROM `cc10_today_pbxcdrs` WHERE proname='zl' AND DATE_FORMAT(starttime,'%Y-%m-%D')=DATE_FORMAT(CURDATE()-1,'%Y-%m-%D')SELECT trunkname AS trunkname FROM `cc10_toda原创 2018-02-02 10:51:16 · 5764 阅读 · 0 评论