1.登录数据库并创建数据库db_ck
创建完成后使用到我们创建的数据库。
2.创建表t_hero
根据hero属性包括（id，name，nickname，age，gender，address，weapon，types）
创建完成后进行查看
使用命令desc t_hero进行查看表建立是否成功;
mysql> create database db_ck;
ERROR 1007 (HY000): Can't create database 'db_ck'; database exists
mysql> use db_ck;
Database changed
mysql> create table t_hero(-> id int,-> name varchar(100),-> nickname varchar(100),-> age int,-> gender varchar(2),-> address varchar(100),-> weapon varchar(100),-> types varchar(100));
Query OK, 0 rows affected (0.02 sec)mysql> desc t_hero;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id | int | YES | | NULL | |
| name | varchar(100) | YES | | NULL | |
| nickname | varchar(100) | YES | | NULL | |
| age | int | YES | | NULL | |
| gender | varchar(2) | YES | | NULL | |
| address | varchar(100) | YES | | NULL | |
| weapon | varchar(100) | YES | | NULL | |
| types | varchar(100) | YES | | NULL | |
+----------+--------------+------+-----+---------+-------+
3.插入我们的四大名著人物数据
insert into db_hero values(1,"孙悟空","齐天大圣",1000,"男","花果山","如意金箍棒","猴子");insert into db_hero values(2,"林黛玉","林妹妹",18,"女","贾府","倒拔垂杨柳","人类");insert into db_hero values(3,"李逵","黑旋风",30,"男","沂州","两柄板斧","人类");insert into db_hero values(4,"紫霞仙子","盘丝大仙",500,"女","盘丝洞","紫霞宝剑","神仙");
4.查看插入的数据
