skill # 查看所有表和库名字 select table_schema, table_name from information_schema.tables select table_name from information_schema.tables where TABLE_SCHEMA='dbname'; Get table names using SELECT statement in MySQL