1.查询所有数据库
SHOW DATABASES;
2.查询库中所有表
写法1:
① USE [DATABASE_NAME];
② SHOW TABLES;
写法2:
SHOW TABLES FROM [DATABASE_NAME]
3. 查询表结构
写法1:
① USE [DATABASE_NAME];
② SHOWCREATE TABLE [TABLE_NAME];
写法2:
SHOW CREATE TABLE [DATABASE_NAME.TABLE_NAME];
4. 查询表所有字段
写法1:
① USE [DATABASE_NAME];
② SHOW COLUMNSFROM [TABLE_NAME];
写法2:
SHOW COLUMNS FROM [DATABASE_NAME.TABLE_NAME];
写法3:
① USE [DATABASE_NAME];
② SHOW FIELDSFROM [TABLE_NAME];