Excel 转为 MySQL 语句
时间：2021-07-01 10:21:17
帮助过：26人阅读
database samp_db
character set gbk;
use samp_db;
create table user(
id int unsigned
not null auto_increment
primary key,
amount int unsigned
not null,
age tinyint unsigned
not null
);
insert into user (id,amount,age)
values (
1,
43200,
35);
insert into user (id,amount,age)
values (
2,
30240,
37);
insert into user (id,amount,age)
values (
3,
72000,
65);
insert into user (id,amount,age)
values (
4,
367200,
44);
insert into user (id,amount,age)
values (
5,
7200,
44);
insert into user (id,amount,age)
values (
6,
108000,
27);
insert into user (id,amount,age)
values (
7,
57600,
45);
insert into user (id,amount,age)
values (
8,
21600,
43);
insert into user (id,amount,age)
values (
9,
144000,
51);
结果如下：
Excel 转为 MySQL 语句
标签：img pre cte create mysql bubuko 填充 mysq weight
