Shulou(Shulou.com)06/01 Report--

MySQL5.0 then provides a new database information_schema, which is used to record the metadata information in MySQL. It is worth noting that it is a virtual database, and there are no related directories and files physically, similar to the dynamic performance table of ORACLE.

Use this virtual database with two examples

1. Delete all tables with the prefix cache under the database gl

Select concat ('drop table gl.',table_name,';') from tables where table_schema='gl' and table_name like' cache%'

two。 Change all tables under the database gl whose storage engine is myisam to innodb

Select concat ('alter table gl.',table_name,' engine=innodb;') from tables where table_schema='gl' and engine='MyISAM'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.