mysql 数据库语法练习（查看）

1.查看所有表 show tables;

 

 2.查看表，所有数据  select * from departments;

 

 3.查看employees库departments表属性

show table status from employees like 'departments''

 

 4.查看employees数据库所有表的属性

use employees;

show table status;

 

 5.查看数据库用户

use mysql;

select host,user,password from user;