【MySQL】数据库基本操作

/*创建数据库db1，指定编码为utf16，校对规则为utf16_bin*/
CREATE DATABASE IF NOT EXISTS db1 CHARACTER SET utf16 COLLATE utf16_bin;

/*查看所有数据库*/
SHOW DATABASES;

/*查看名字含有db的数据库*/
SHOW DATABASES LIKE "%db%";

/*查看数据库db1的创建信息*/
SHOW CREATE DATABASE db1;

/*多种方式查看mysql服务器支持的字符集*/
SHOW CHARACTER SET;

SELECT * FROM information_schema.character_sets;

SELECT character_set_name, default_collate_name, DESCRIPTION,
maxlen FROM information_schema.character_sets;

/*多种方式查看mysql服务器支持的校对规则*/
SHOW COLLATION;

SELECT * FROM information_schema.collations /*where collation_name like 'utf8%'*/;

/*查看当前数据库的字符集*/
SHOW VARIABLES LIKE 'character%';

/*查看当前数据库的校对规则*/
SHOW VARIABLES LIKE 'collation%';

/*选择数据库db1*/
USE db1;

/*数据库存在，改变数据库的编码规则和校对规则*/
ALTER DATABASE db1 CHARACTER SET utf16 COLLATE utf16_bin;

/*删除数据库db1*/
DROP DATABASE IF EXISTS db1;