1查看已有数据库
语法格式:SHOW DATABASES;
mysql> show databases;
![](https://i-blog.csdnimg.cn/blog_migrate/3eabc214c265050ed5c0bf1cd745eb85.png)
2
创建数据库
语法格式:CREATE DATABASES db_name;
mysql> create database stusys;
![](https://i-blog.csdnimg.cn/blog_migrate/b7f354628d788013ad67327926998532.png)
3
选择数据库
语法格式:USE db_name;
mysql> use stusys;
![](https://i-blog.csdnimg.cn/blog_migrate/e7acd1b1629f4e718b717e957e22704c.png)
4修改数据库
语法格式:ALTER DATABASE db_name
CHARACTER SET charst_name
COLLAGE collction_name;
mysql> alter database stusys
-> default character set gb2312
-> default collate gb2312_chinese_ci;
————————————————
![](https://i-blog.csdnimg.cn/blog_migrate/4572f03344e50c6953f12aa776ed1c5f.png)
删除数据库
5.
语法格式:DROP DATABASES db_name;
mysql> drop database stusys;
![](https://i-blog.csdnimg.cn/blog_migrate/ac47c84ade2799892353e5840829a546.png)
二.表的创建
一.创建一个student表
语法格式:mysql> create table student
-> (
-> sno char(6) not null primary key,
-> sname char(8) not null,
-> ssex char(2) not null default '男',
-> sbirthday date not null,
-> speciality char(12) null,
-> tc tinyint null
-> );
Query OK, 0 rows affected (0.07 sec)
![](https://i-blog.csdnimg.cn/blog_migrate/d309f12012f945fb503b158f336ec42d.png)
![](https://i-blog.csdnimg.cn/blog_migrate/3968b3ab28ba69fce897e979da4cd74c.png)
二.创建一个course表
语法格式:
mysql> create table course
-> (
-> cno char(4) not null primary key,
-> cname char(16) not null,
-> credit tinyint null
-> );
Query OK, 0 rows affected (0.03 sec)
![](https://i-blog.csdnimg.cn/blog_migrate/fdbb13e78cd00194342052a978aeee4d.png)
三.创建一个score表
语法格式:
create table score
-> (
-> sno char(6) not null primary key,
-> cno char(4) not null primary key,
-> grade tinyint null
-> );
![](https://i-blog.csdnimg.cn/blog_migrate/2c4874ebd3d876b3e2a6a7a892bac2a9.png)