数据库第一次作业

1.创建一个英雄表

create table t_hero (
? ? ?id int primary key auto_increment,
? ? ?name varchar(10) unique not null,
? ? ?gender char(5) check (gender in ('男','女')),
? ? ?grade char(5) default '5星',
? ? ?`groups` char(5) check (`groups` in ('毁灭','巡猎','智识','存护','虚无','丰饶')),
? ? ?tel char(11) ? default '88888888888');

?insert into t_hero values(null,'姬子','女',default,'智识',01020536551);
Query OK, 1 row affected (0.01 sec)

?insert into t_hero values(null,'刃','男',default,'毁灭',default);
Query OK, 1 row affected (0.00 sec)

?insert into t_hero values(null,'单恒','男','4星','毁灭',default);
Query OK, 1 row affected (0.00 sec)

?insert into t_hero values(null,'霍霍','女','5星','丰饶',default);
Query OK, 1 row affected (0.00 sec)

2安装MySQL

配置环境变量