You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

11 lines
1.1 KiB

INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('01', '张一', '', 1, 5200);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('02', '张二', '', 1, 5100);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('03', '张三', '', 1, 5000);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('04', '张四', '', 1, 4900);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('05', '张五', '', 1, 4800);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('06', '张六', '', 1, 5200);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('07', '张七', '', 1, 5100);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('08', '张八', '', 0, 5000);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('09', '张久', '', 0, 5000);
INSERT INTO mydata.workers (W_id, W_name, W_sex, W_stat, W_salary) VALUES ('10', '张石', '', 0, 5000);