--注释
也可以使用#号
---创建数据库
--中文字符集
set names gbk 适于Windows
create databse tmz charset utf8;
Z3Z(SHOA9E9M0%H8KS{WP{1.png
--创建中文数据库
点击方可加载
![]RVFR{IVEO72C`]6_T2NO9H.png](https://upload-images.jianshu.io/upload_images/13008199-ae12513aad790e28.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
查看所有数据库
show databases;
![V9DALRCDT[BI38O7I`JXPI.png
--创建数据库
create databases informationtest charset utf8;
![6AC6553Y1(N9H~FFCCM]5CJ.png](https://upload-images.jianshu.io/upload_images/13008199-b0750f197be0e041.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
--查看以information_开始的数据库
show databases like 'information';
912RJMY@TGF4XMQB5S2_6~G.png
查看表的创建语句
show create databases informatio](https://upload-images.jianshu.io/upload_images/13008199-1a8e69a6747f9f29.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
