1、创建一个英雄表(hero)
id 主键
name
nickname
address
groups
telphonecreate table hero (
id int primary key auto_increment,
name varchar(50) not null,
nickname varchar(255),
address varchar(50),
groups varchar(50),
email varchar(50),
telphone int(20)
);desc hero;
insert into hero(id,name,nickname,address,groups,email,telphone) values (1,'鲁智深',"镇关西","花果山水帘洞","护送唐三藏取经",'3454356@qq.com',529385234);
...insert into hero(id,name,nickname,address,groups,email,telphone) values (30,'林冲', '八十万禁军教头', '吴郡富春', '吴大帝', '35444@qq.com',53453654);
创建MySQL表并插入一些数据(练习)
于 2024-01-12 23:00:10 首次发布