清山博客

摘要： /*1.查询所有数据库*/show databases;/*2.查询所有数据表*/select * from information_schema.tables where table_schema='world'/*3.查询指定表的所有字段*/select * from information_schema.columnswhere table_schema='world'and table_name='city' 阅读全文