作业要求
1、创建一个英雄表(hero)
主键
name 名字
nickname 昵称
address 地址
groups 组别
email 电子邮箱
telphone 电话
实验步骤:
步骤一:创建数据库
mysql> create database db_hero;
mysql> use db_hero;
mysql> show tables;
步骤二:创建表
mysql> CREATE TABLE IF NOT EXISTS t_heros (
-> id int primary key auto_increment,
-> name varchar(50) not null unique,
-> nickname varchar(255) unique,
-> address varchar(20) check(address in("三国", "西游")),
-> `groups`varchar(20) not null,
-> email varchar(20),
-> telphone int
-> );
检查
show tables;
desc t_hreo;
步骤三:插入数据
insert into t_hero values(null, "关羽", "云长" , "三国", " 蜀" , "123@qq.123", 0123456789);
insert into t_hero values(null, "赵云", "子龙" , "三国", " 蜀" , "123@qq.122", 0223456789);
insert into t_hero values(null, "张辽", "文远" , "三国", " 魏" , "123@qq.121", 0323456789);
insert into t_hero values(null, "甘宁", "兴霸" , "三国", " 吴" , "123@qq.124", 0423456789);mysql> select * from t_hero;