一、登錄數據庫并創建數據庫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>