Mysql創(chuàng)建數(shù)據(jù)庫(kù)名class,并設(shè)置字符集為utf8排序規(guī)則為utf8_general_ci
create database if not exists class default charset utf8 collate utf8_general_ci;
查看Mysql服務(wù)器全部數(shù)據(jù)庫(kù)命令:show databases;
修改數(shù)據(jù)庫(kù)默認(rèn)字節(jié)集為gbk点楼,排序規(guī)則為gbk_chinese_ci
alter database class character set gbk collate gbk_chinese_ci;
改變扫尖,數(shù)據(jù)庫(kù),【要改變的數(shù)據(jù)庫(kù)名】掠廓,字節(jié)集藏斩,設(shè)置,校對(duì)排序規(guī)則却盘,gbk_chinese_ci
Mysq刪除數(shù)據(jù)庫(kù)
drop database class;
刪除狰域,數(shù)據(jù)庫(kù),(數(shù)據(jù)庫(kù)名)