MySQL基本建表操作

一、创建数据库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、查看插入的数据