March 1st, 2013, 01:25 PM
Find any table in mysql that uses partitioning
I tried this:
WHERE TABLE = 'PARTITIONS';
and got this:
Error Code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE = 'PARTITIONS'' at line 3
My question is how would you find all table in either the schema or table in all instances that use partitioning and then displays the associated columns?
March 1st, 2013, 02:08 PM
Actually your question is "What's wrong with my query?" The answer to that is "'table' is a reserved word".