MySQL课堂笔记

https://blog.csdn.net/weixin_65615903?spm=1000.2115.3001.5343

一、课程网络资源：

1.www.csdn.net

2.www.runoob.com

3.www.liaoxuefeng.com

4、B站

第四章 Mysql数据库和表的命令操作

1.数据库（DATABASE）操作

（1）创建数据库

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sakila |

| sys |

| world |

+--------------------+

7 rows in set (0.00 sec)

（2）查看数据库

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sakila |

| stusys |

| sys |

| world |

+--------------------+

（3）选择数据库

mysql> use database stusys;

ERROR 1049 (42000): Unknown database 'database'

mysql> use stusys;

Database changed

（4）修改数据库

mysql> use stusys;

Database changed

mysql> alter database;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql> alter database stusys

->

-> default character set gb2312

-> default collate gb2312_chinese_ci;

Query OK, 1 row affected (0.01 sec)

（5）删除数据库

mysql> drop database stusys;

ERROR 1008 (HY000): Can't drop database 'stusys'; database doesn't exist

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sakila |

| sys |

| world |

+--------------------+

6 rows in set (0.01 sec)

mysql> drop database stusys;

ERROR 1008 (HY000): Can't drop database 'stusys'; database doesn't exist

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sakila |

| sys |

| world |

+--------------------+

6 rows in set (0.01 sec)