1、查看所有數(shù)據(jù)庫
show databaese;
2、查看當(dāng)前所用的數(shù)據(jù)庫
show databases();
3、切換數(shù)據(jù)庫
use 數(shù)據(jù)庫名 ;
4、創(chuàng)建數(shù)據(jù)庫
create database (數(shù)據(jù)庫名) charset = utf8;
5、刪除數(shù)據(jù)庫
drop database 數(shù)據(jù)庫名;
- 顯示所有表
show tables;