What type of MySQL table schemas
Since I always forget stuff like this. This is the SQL query to detect mysql table schemas type (thanks to Darren.B) :
SELECT table_name, table_schema, table_type, engine FROM information_schema.tables where table_schema not in ('information_schema', 'mysql'); |
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
thx that was helpfull, 1 kudos for the tips !