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.查看插入的數據

?