SQL操作

●创建数据库

create database 'mydatabase' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;     // utf8create database mydatabase DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;        // gbk

●修改数据库字符集

alter database mydb character set utf8;

●修改表格字符集

alter table mytable DEFAULT CHARACTER SET utf8;

●显示所有数据库或表

show databases;show tables;