一、登录数据库并创建数据库db_ck
二、创建表t_hero
表属性包括（id，name，nickname，age，gender，address，weapon，types）
mysql> create table t_hero(-> id int,-> name varchar(100),-> age int,-> gender varchar(2),-> address varchar(100),-> weapon varchar(100),-> types varchar(100));
Query OK, 0 rows affected (0.06 sec)mysql> desc t_hero;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id | int | YES | | NULL | |
| name | 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 | |
+----------+--------------+------+-----+---------+-------+
三、插入我们的四大名著人物数据
mysql> insert into t_hero values(1,"孙悟空",800,"男","花果山","如意金箍棒","妖");
Query OK, 1 row affected (0.01 sec)mysql> insert into t_hero values(2,"林黛玉",20,"女","贾府","无","人类");
Query OK, 1 row affected (0.01 sec)mysql> insert into t_hero values(3,"李逵",30,"男","沂州","两柄板斧","人类");
Query OK, 1 row affected (0.01 sec)mysql> insert into t_hero values(4,"赵云",27,"男","常山","涯角枪","人类");
Query OK, 1 row affected (0.01 sec)mysql>四、查看表的数据
mysql> select * from t_hero;
+------+--------+------+--------+---------+------------+-------+
| id | name | age | gender | address | weapon | types |
+------+--------+------+--------+---------+------------+-------+
| 1 | 孙悟空 | 800 | 男 | 花果山 | 如意金箍棒 | 妖族 |
| 1 | 孙悟空 | 800 | 男 | 花果山 | 如意金箍棒 | 妖 |
| 2 | 林黛玉 | 20 | 女 | 贾府 | 无 | 人类 |
| 3 | 李逵 | 30 | 男 | 沂州 | 两柄板斧 | 人类 |
| 4 | 赵云 | 27 | 男 | 常山 | 涯角枪 | 人类 |
+------+--------+------+--------+---------+------------+-------+
5 rows in set (0.00 sec)mysql>
