Mysql 创建学校管理数据库

最新推荐文章于 2025-06-24 10:42:38 发布

原创

最新推荐文章于 2025-06-24 10:42:38 发布 · 3.7k 阅读

22 ·

CC 4.0 BY-SA版权

-- 创建数据库
create database m_school charset utf8;

-- 设置命令窗口编码格式
set names gbk;
-- -----------------------------------------------------------------------
-- 创建学生表
use m_school;
create table student(
id int unsigned  primary key auto_increment,
number int unsigned unique key not null comment "学号",
name varchar(12) not null comment "姓名",
sex enum("men","women") not null comment "性别",
age int unsigned  default 18 not null comment"年龄",
class varchar(12) comment"班级"
)charset utf8;

desc student;
+--------+---------------------+------+-----+---------+-------+
| Field  | Type                | Null | Key | Default | Extra |
+--------+---------------------+------+-----+---------+-------+
| id     | int(10) unsigned    | NO   | PRI | NULL    |       |
| number | int(10) unsigned    | YES  | UNI | NULL    |       |
| name   | varchar(12)         | NO   |     | NULL    |       |
| sex    | enum('men','women') | NO   |     | NULL    |       |
| age    | in