MySQL5.7，创建数据库，创建表并插入内容

创建数据库，创建表并插入内容

创建数据库

create database db_books default  character set utf8mb4;

创建表并定义

create table t_xi(

id int primary key,

username varchar(255),

nickname varchar(255),

address varchar(255),

age int, gender varchar(255),

intro varchar(255),

seat varchar(255));



create table t_hong(

id int primary key,

username varchar(255),

nickname varchar(255),

address varchar(255),

age int, gender varchar(255),

intro varchar(255),

seat varchar(255));



create table t_shui(

id int primary key,

username varchar(255),

nickname varchar(255),

address varchar(255),

age int, gender varchar(255),

intro varchar(255),

seat varchar(255));



create table t_san(

id int primary key,

username varchar(255),

nickname varchar(255),

address varchar(255),

age int, gender varchar(255),

intro varchar(255),

seat varchar(255));

 

 

 

录入内容

insert into t_xi values(5,"小白龙","白龙马","东海",18,"男","能奔驰",5);
#插入内容

select * from t_shui
#查看表内容