在MySQL中,如果在In这样的子查询中加入Limit,你可能会遇到错误:mysql> SELECT table_schema,table_name,partition_name,tablespace_name,partition_ordinal_position,create_time,update_time,check_time,checksum FROM information_schema.partitions WHERE table_name='event_by_day' and partition_ordinal_position not in (select partition_ordinal_position FROM information_schema.partitions WHERE table_name='event_by_day' order by partition_ordinal_position desc limit 0,3);
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
mysql>暂时,解决该问题的方法是,再增加一层子查询,如下:mysql> SELECT table_schema,table_na
...
继续阅读
(29)