--注釋
也可以使用#號(hào)
---創(chuàng)建數(shù)據(jù)庫(kù)
--中文字符集
set names gbk 適于Windows
create databse tmz charset utf8;
[圖片上傳失敗...(image-473804-1562841620977)]
--創(chuàng)建中文數(shù)據(jù)庫(kù)
點(diǎn)擊方可加載
![]RVFR{IVEO72C`]6_T2NO9H.png](https://upload-images.jianshu.io/upload_images/13008199-ae12513aad790e28.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
查看所有數(shù)據(jù)庫(kù)
show databases;
![V9DALRCDT[BI38O7I`JXPI.png
--創(chuàng)建數(shù)據(jù)庫(kù)
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_開(kāi)始的數(shù)據(jù)庫(kù)
show databases like 'information';
查看表的創(chuàng)建語(yǔ)句
show create databases informatio](https://upload-images.jianshu.io/upload_images/13008199-1a8e69a6747f9f29.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)
