05--MySQL自学教程：DDL（Data Definition Language：数据库定义语言）操作数据库（一）

本是古典何须时尚 2022-06-16 13:57 179阅读 0赞

# **1.DDL（Data Definition Language：数据库定义语言）概览** #

**DDL（Data Definition Language：数据库定义语言）**

![这里写图片描述][SouthEast]

# **2.DDL对数据库的操作** #

**1）方法概览**

![这里写图片描述][SouthEast 1]

--------------------

**2）分别演示**

--------------------

**show databases;//查看该帐号下的所有数据库**  
![这里写图片描述][SouthEast 2]

--------------------

**create database test1;//创建数据库**  
![这里写图片描述][SouthEast 3]

--------------------

**show create database test1;//查看创建的指定数据库的信息，默认字符集编码是utf-8;**  
![这里写图片描述][SouthEast 4]

--------------------

**SHOW CHARACTER SET;;//查看mysql支持的所有字符集**  
![这里写图片描述][SouthEast 5]

--------------------

**alter database test1 character set gbk;//修改数据库的字符集编码**  
![这里写图片描述][SouthEast 6]

--------------------

**create database test2 character set gb2312;//直接创建一个字符集编码为gb2312的数据库**  
![这里写图片描述][SouthEast 7]

--------------------

**drop database test2;//删除数据库**  
![这里写图片描述][SouthEast 8]

# **3.DDL对表的操作** #

**见下一节，链接地址：[http://blog.csdn.net/baidu\_37107022/article/details/72347044][http_blog.csdn.net_baidu_37107022_article_details_72347044]**

[SouthEast]: /images/20220616/e27fe85a00f744f2a4393b7ddc1071ed.png
[SouthEast 1]: /images/20220616/652153ae9da64e35b772c6dc5930afd7.png
[SouthEast 2]: /images/20220616/8771cd14cbee4b86a48ffd7efdf35597.png
[SouthEast 3]: /images/20220616/8ae720ca5261485ca137377277666713.png
[SouthEast 4]: /images/20220616/c6e03c65259b45dbbbbbaa03326e6077.png
[SouthEast 5]: /images/20220616/208101f2461d40d095a2c7f940ea5588.png
[SouthEast 6]: /images/20220616/fc550a8a318641599e98755b58343fc2.png
[SouthEast 7]: /images/20220616/8fb6d4926c8e4f7eaa0d187d3b95ae71.png
[SouthEast 8]: /images/20220616/15287c825e654469ae66d96e63cd3c24.png
[http_blog.csdn.net_baidu_37107022_article_details_72347044]: http://blog.csdn.net/baidu_37107022/article/details/72347044