登录数据库
mysql -u root -p
显示数据库
show databases;
选择数据库
use dbname;
显示数据库中的表
show tables;
新建数据库
create database dbname;
删除数据库
dorp database dbname;
显示表结构
desc dbname;
查询数据库
selcet *from dbname;
mysql -u root -p
show databases;
use dbname;
show tables;
create database dbname;
dorp database dbname;
desc dbname;
selcet *from dbname;