In this part I present DBA's handy syntax for schema and table operations and maintenance.
Confession: while I love INFORMATION_SCHEMA's power, I just hate writing queries against it. It's just so much typing! Just getting the list of tables in a schema makes for this heavy duty query:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='sakila' AND TABLE_TYPE='BASE TABLE';
When a join is involved this really becomes a nightmare. I think it's cumbersome, and as result, many do …[Read more]