帮我生成20条插入语句,registry_code取值为“C22_a1l34b05f75gzuga”、“C16_xi1334531ldpggxg”,data_type 取值为“image”,"pathology","gene"
时间: 2023-12-28 18:03:37 浏览: 37
好的,以下是20条插入语句:
```
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-01-01', '2022-01-31', '/path/to/image1.jpg', 'image', 1024);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-01-01', '2022-01-31', '/path/to/image2.jpg', 'image', 2048);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-02-01', '2022-02-28', '/path/to/image3.jpg', 'image', 3072);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-02-01', '2022-02-28', '/path/to/pathology1.txt', 'pathology', 4096);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-03-01', '2022-03-31', '/path/to/pathology2.txt', 'pathology', 5120);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C16_xi1334531ldpggxg', '2022-01-01', '2022-01-31', '/path/to/image4.jpg', 'image', 6144);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C16_xi1334531ldpggxg', '2022-01-01', '2022-01-31', '/path/to/image5.jpg', 'image', 7168);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C16_xi1334531ldpggxg', '2022-02-01', '2022-02-28', '/path/to/image6.jpg', 'image', 8192);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C16_xi1334531ldpggxg', '2022-02-01', '2022-02-28', '/path/to/gene1.txt', 'gene', 9216);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C16_xi1334531ldpggxg', '2022-03-01', '2022-03-31', '/path/to/gene2.txt', 'gene', 10240);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-04-01', '2022-04-30', '/path/to/image7.jpg', 'image', 11264);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-04-01', '2022-04-30', '/path/to/pathology3.txt', 'pathology', 12288);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-05-01', '2022-05-31', '/path/to/pathology4.txt', 'pathology', 13312);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C16_xi1334531ldpggxg', '2022-04-01', '2022-04-30', '/path/to/image8.jpg', 'image', 14336);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C16_xi1334531ldpggxg', '2022-04-01', '2022-04-30', '/path/to/gene3.txt', 'gene', 15360);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C16_xi1334531ldpggxg', '2022-05-01', '2022-05-31', '/path/to/gene4.txt', 'gene', 16384);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-06-01', '2022-06-30', '/path/to/image9.jpg', 'image', 17408);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-06-01', '2022-06-30', '/path/to/pathology5.txt', 'pathology', 18432);
INSERT INTO `t_data_package_record` (`registry_code`, `start_date`, `end_date`, `file_path`, `data_type`, `file_size`)
VALUES ('C22_a1l34b05f75gzuga', '2022-07-01', '2022-07-31', '/path/to/pathology6.txt', 'pathology', 19456);
```