一、创建数据库db_ck和表db_hero

1、创建表

mysql> create database db_ck default charset="utf8mb4";mysql> create table if not exists db_hero(-> id int not null,-> name varchar(100) not null,-> nickname varchar(100),-> age int,-> gender varchar(2),-> address varchar(100),-> weapon varchar(100),-> type varchar(100)-> );

2、查看创建好的表

二、创建表t_hero

1、先进入数据库Db_ck

 USE Db_Ck;

a、查看是否进入数据库：

 SELECT DATABASE();

2、创建表t_Hero

a、我们可以先在文本文档里面写好粘贴进去，因为直接写的话，出现错误需要重新开始

 CREATE TABLE IF NOT EXISTS t_Hero(-> bookId INT PRIMARY KEY AUTO_INCREMENT, --- 设置主键并且设置自增-> personName VARCHAR(100),-> bookName VARCHAR(100)-> );

b、查看创建好的表结构

> SHOW COLUMNS FROM t_Hero;

3、插入数据

a、插入数据

 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,"女","盘丝洞","紫霞宝剑","神仙");

b、查看插入的数据