SELECT TABLE_NAME,PARTITION_DESCRIPTION
FROM `information_schema`.`PARTITIONS`
WHERE table_schema = 'xxxx'
AND LENGTH(PARTITION_DESCRIPTION) = 13
AND PARTITION_NAME IS NOT NULL
ORDER BY PARTITION_DESCRIPTION DESC;
SELECT TABLE_NAME,PARTITION_DESCRIPTION
FROM `information_schema`.`PARTITIONS`
WHERE table_schema = 'xxxx'
AND LENGTH(PARTITION_DESCRIPTION) = 13
AND PARTITION_NAME IS NOT NULL
AND TABLE_NAME LIKE 'xxx%'
ORDER BY PARTITION_DESCRIPTION DESC ;上面的一段sql查不到数据,下面的这段sql可以查看数据
FROM `information_schema`.`PARTITIONS`
WHERE table_schema = 'xxxx'
AND LENGTH(PARTITION_DESCRIPTION) = 13
AND PARTITION_NAME IS NOT NULL
ORDER BY PARTITION_DESCRIPTION DESC;
SELECT TABLE_NAME,PARTITION_DESCRIPTION
FROM `information_schema`.`PARTITIONS`
WHERE table_schema = 'xxxx'
AND LENGTH(PARTITION_DESCRIPTION) = 13
AND PARTITION_NAME IS NOT NULL
AND TABLE_NAME LIKE 'xxx%'
ORDER BY PARTITION_DESCRIPTION DESC ;上面的一段sql查不到数据,下面的这段sql可以查看数据
解决方案 »
- mysql触发器
- 求教,安装mysql-5.5.29的问题
- 帮忙写一个通过父节点ID查询所有子节点ID的SQL
- mysql load data infile 怎么跳过某一行
- 遍历游标的时候,不能执行动态sql(prepate stmt from @v_Sql)吗?
- mysql存储过程 字符连接
- 在MySQL-Font里的“SQL编辑器”里输入values(‘中文’)半角?
- java怎么链接数据库?(在线等待)
- 請問在Linux下copy出來的mySQL文檔可不可以直接在Window2000下使用
- 充分发挥网络优势和自由精神,共同开发维护我们自己的网站
- mysql 用什么sql 语句 去查询谁操作某个表里的数据
- win7下安装mysql数据库的路径选择
灵异的是上段居然查不到数据,下段可以查到