######### Begin #########
create database if not exists library default character set 'utf8';
######### End ##########
SELECT schema_name,DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA where SCHEMA_NAME='library';
关卡二:创建借阅人员信息表
use library;
DROP TABLE IF EXISTS `Class_User`;
######### Begin #########
create table Class_User(
classNo tinyint(4) primary key not null,
cname varchar(20) unique not null,
term tinyint(4) default 30 not null,
ceilingNum tinyint(4) not null);
######### End ##########
SELECT CONSTRAINT_SCHEMA,TABLE_NAME,CONSTRAINT_TYPE FROM information_schema.`TABLE_CONSTRAINTS` where CONSTRAINT_SCHEMA='library' and TABLE_NAME='Class_User';
## show create table Class_User;
desc Class_User;