利用CREATE DATABASE语句创建bedroom数据库
MySQL>CREATE DATABASE bedroom;
MySQL>CREATE TABLE ‘学生’(‘学号’ char(8) CONSTRAINT PRIMARY KEY,
>‘姓名’ char(8),’性别’ char(2) NOT NULL DEFAULT ‘男’,’专业’ varchar(50)
> NOT NULL,’年龄’ int);
MySQL>CREATE TABLE ‘寝室’(‘寝室编号’ char(8) CONSTRAINT PRIMARY KEY,