#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    13
    Rep Power
    0

    Find any table in mysql that uses partitioning


    I tried this:

    SELECT *
    FROM information_schema.tables
    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?
  2. #2
  3. Transforming Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,249
    Rep Power
    9400
    Actually your question is "What's wrong with my query?" The answer to that is "'table' is a reserved word".

IMN logo majestic logo threadwatch logo seochat tools logo