创建一个数据库,在库里创建一个水浒表
create datebase meme character set utf8;
use meme;
use meme;
create table shuihu (
- id int,
- name varchar(50),
- nickname varchar(50),
- gender varchar(50),
- age int ,
- address varchar(50) )
输入水浒的英雄基本信息
insert into shuihu (id ,name,nickname,starname,gender,age,address)values(1,“宋江”,“及时雨”,“天魁星”,“男”,“38”,“山东省”)
insert into shuihu (id ,name,nickname,starname,gender,age,address)values(2,“公孙胜”,“入云龙”,“天闲星”,“男”,“30”,“四川省”)…以此类推,创建更多水浒英雄表格
查看表格select * from shuihu;
看到如图表格即创建成功!