Mysql
全绽开发工程师
不断学习!
展开
-
mysql order by + limit 效率低下问题
原SQL语句 SELECT tf.* FROM tran_flow tf WHERE TTF_GRPID = '0073' AND TTF_OPRNO = 'cs5' And TTF_BSNCODE = '0101' AND LEFT('20220120', 8) <= LEFT(TTF_SUBMITTIME, 8) AND LEFT('20230120', 8) >= LEFT(TTF_SUBMITTIME, 8) AND (case when '' = '' then 1 = 1 els原创 2021-11-12 10:24:39 · 965 阅读 · 0 评论 -
MySQL与Oracle表结构查询语句
MySQL: SELECT COLUMN_NAME 字段名称, COLUMN_TYPE 字段类型, COLUMN_DEFAULT 默认值, CHARACTER_MAXIMUM_LENGTH AS 最大长度, ( CASE WHEN is_nullable = 'NO' THEN '否' ELSE '是' END ) AS 是否可空, ( CASE WHEN column_key = 'PRI' THEN '是' ELSE '否' END原创 2020-08-23 16:36:46 · 214 阅读 · 0 评论 -
MySQL根据日期查询常用语句
--今天 select * from 表名 where to_days(时间字段名) = to_days(now()); --昨天 SELECT * FROM 表名 WHERE TO_DAYS( NOW( ) ) - TO_DAYS( 时间字段名) <= 1 --本周 SELECT * FROM 表名 WHERE YEARWEEK( date_format( 时间字段名,'%Y-%m-%d' ) ) = YEARWEEK( now() ) ; --本月 SELECT * FROM原创 2020-08-23 16:33:51 · 222 阅读 · 0 评论