56,687
社区成员
发帖
与我相关
我的任务
分享
id number flag_1 flag_2 delete_true_or_false
428101 123456 1 0 0
428102 123456 1 0 0
428104 123456 1 0 1
428114 1234567 1 0 0
428115 1234567 1 0 1
428131 1234567 1 0 0
428149 12345678 2 1 1
428150 12345678 2 1 0
428174 123456789 3 0 0
428175 1234567890 3 0 1
428176 111111 3 2 0
428187 111111 3 1 0
428191 111111 3 0 1
id number flag_1 flag_2 delete_true_or_false
428131 1234567 1 0 0
428150 12345678 2 1 0
428174 123456789 3 0 0
428176 111111 3 2 0
428187 111111 3 1 0
create table test (
id bigint(11) NOT NULL AUTO_INCREMENT,
number varchar(30) NOT NULL,
flag_1 int(11) NOT NULL,
flag_2 int(11) NOT NULL,
delete_true_or_false bit(1) NOT NULL,
PRIMARY KEY (`id`)
)ENGINE=InnoDB;
INSERT INTO test values(428101,'123456',1,0,0);
INSERT INTO test values(428102,'123456',1,0,0);
INSERT INTO test values(428104,'123456',1,0,1);
INSERT INTO test values(428114,'1234567',1,0,0);
INSERT INTO test values(428115,'1234567',1,0,1);
INSERT INTO test values(428131,'1234567',1,0,0);
INSERT INTO test values(428149,'12345678',2,1,1);
INSERT INTO test values(428150,'12345678',2,1,0);
INSERT INTO test values(428174,'123456789',3,0,0);
INSERT INTO test values(428175,'1234567890',3,0,1);
INSERT INTO test values(428176,'111111',3,2,0);
INSERT INTO test values(428187,'111111',3,1,0);
INSERT INTO test values(428191,'111111',3,0,1);
id number flag_1 flag_2 delete_true_or_false
428131 1234567 1 0 0
428150 12345678 2 1 0
428174 123456789 3 0 0
428176 111111 3 2 0
428187 111111 3 1 0
就是这个啊。。上面有哦。。跪求大师指点.