【sqlite】联查Join更新

已于 2023-05-14 14:13:51 修改
阅读量1.1k 收藏
点赞数
分类专栏： 数据库 文章标签： sqlite 联查更新 join 参照更新
于 2023-05-13 18:01:50 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/youcheng_ge/article/details/130660370
版权

系列文章

C#底层库–MySQLBuilder脚本构建类（select、insert、update、in、带条件的SQL自动生成）
本文链接：https://blog.csdn.net/youcheng_ge/article/details/129179216

C#底层库–MySQL数据库操作辅助类（推荐阅读）
本文链接：https://blog.csdn.net/youcheng_ge/article/details/126886379

C#底层库–SQLite的使用（小型、本地数据库）
本文链接：https://blog.csdn.net/youcheng_ge/article/details/123666958

【提高编程效率】Excel数据批量导入数据库
本文链接：https://blog.csdn.net/youcheng_ge/article/details/126427323

【Oracle】数据库服务器限制ip访问
本文链接：https://blog.csdn.net/youcheng_ge/article/details/122220930

【Oracle】Excel导入数据教程
本文链接：https://blog.csdn.net/youcheng_ge/article/details/118722756

【Oracle】数据库还原教程_数据泵
本文链接：https://blog.csdn.net/youcheng_ge/article/details/118054855

【SQL】如何查询表字段并识别主键
本文链接：https://blog.csdn.net/youcheng_ge/article/details/110820405

【SQL】outer apply的用法
本文链接：https://blog.csdn.net/youcheng_ge/article/details/79903489

【SQL】多表连接重复数据处理
本文链接：https://blog.csdn.net/youcheng_ge/article/details/79903619

MySQL安装教程（详细）
本文链接：https://blog.csdn.net/youcheng_ge/article/details/126037520

MySQL卸载教程（详细）
本文链接：https://blog.csdn.net/youcheng_ge/article/details/129279265

【MySQL】group by分类汇总，如何增加“总计”字段?
本文链接：https://blog.csdn.net/youcheng_ge/article/details/128217837

【MySQL】WITH CHECK OPTION的用法
本文链接：https://blog.csdn.net/youcheng_ge/article/details/128147196

【MySQL】使用存储过程插入千万级数据如何提升效率？
本文链接：https://blog.csdn.net/youcheng_ge/article/details/77728189

【MySQL】数据库表行列转置的实现
本文链接：https://blog.csdn.net/youcheng_ge/article/details/77625052

【MySQL】查询中，NULL值转换为空字符串
本文链接：https://blog.csdn.net/youcheng_ge/article/details/130381878

文章目录

前言

本专栏为【数据库】，主要介绍SQL的功能与特点、SQL数据定义语言（表、视图、索引、约束）、SQL数据操作语言（数据检索、数据插入、数据删除、数据更新）、创建与删除触发器、SQL数据控制语言（安全性和授权、事务处理）以及嵌入式SQL。
如果你对本专辑感兴趣，持续关注吧。大家有任何问题，也可以评论区反馈，私信我。
在这里插入图片描述

一、技术介绍

采用join联查形式，更新表数据。sqlite不像MySQL、SQL server 支持update 表1 left join 表2 on 表1.字段=表2.字段 set 表1.字段=表2.字段这种写法。
sqlite只支持子查询形式更新。

二、测试用例

2.1 钨条标签表（主表）

创建表 T_Main，脚本如下：

--
-- 由SQLiteStudio v3.3.3 产生的文件 周六 5月 13 17:57:27 2023
--
-- 文本编码：System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- 表：T_main
DROP TABLE IF EXISTS T_main;
CREATE TABLE T_main (id INTEGER PRIMARY KEY ASC AUTOINCREMENT, supply_no VARCHAR (20), code_no VARCHAR (20), date VARCHAR (40));
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (15, '2023-1L-2', '3001', '2023-04-10 14:42:27');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (16, '2023-1L-2', '3002', '2023-04-10 14:42:27');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (17, '2023-1L-2', '3003', '2023-04-10 14:47:30');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (18, '2023-1L-2', '3004', '2023-04-10 14:47:30');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (19, '2023-1L-2', '3005', '2023-04-10 14:54:38');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (20, '2023-1L-2', '3006', '2023-04-10 14:54:38');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (21, '2023-1L-2', '3007', '2023-04-10 15:04:06');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (22, '2023-1L-2', '3008', '2023-04-10 15:04:06');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (23, '2023-1L-2', '3009', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (24, '2023-1L-2', '300A', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (25, '2023-1L-2', '300B', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (26, '2023-1L-2', '300C', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (27, '2023-1L-2', '300D', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (28, '2023-1L-2', '300E', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (29, '2023-1L-2', '300F', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (30, '2023-1L-2', '300G', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (31, '2023-1L-2', '300H', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (32, '2023-1L-2', '300J', '2023-04-10 15:05:15');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (33, '2023-10L-2（3#）', '300K', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (34, '2023-10L-2（3#）', '300L', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (35, '2023-10L-2（3#）', '300M', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (36, '2023-10L-2（3#）', '300N', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (37, '2023-10L-2（3#）', '300P', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (38, '2023-10L-2（3#）', '300Q', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (39, '2023-10L-2（3#）', '300R', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (40, '2023-10L-2（3#）', '300S', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (41, '2023-10L-2（3#）', '300T', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (42, '2023-10L-2（3#）', '300V', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (43, '2023-10L-2（3#）', '300W', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (44, '2023-10L-2（3#）', '300X', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (45, '2023-10L-2（3#）', '300Y', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (46, '2023-10L-2（3#）', '3010', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (47, '2023-10L-2（3#）', '3011', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (48, '2023-10L-2（3#）', '3012', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (49, '2023-10L-2（3#）', '3013', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (50, '2023-10L-2（3#）', '3014', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (51, '2023-10L-2（3#）', '3015', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (52, '2023-10L-2（3#）', '3016', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (53, '2023-10L-2（3#）', '3017', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (54, '2023-10L-2（3#）', '3018', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (55, '2023-10L-2（3#）', '3019', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (56, '2023-10L-2（3#）', '301A', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (57, '2023-10L-2（3#）', '301B', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (58, '2023-10L-2（3#）', '301C', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (59, '2023-10L-2（3#）', '301D', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (60, '2023-10L-2（3#）', '301E', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (61, '2023-10L-2（3#）', '301F', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (62, '2023-10L-2（3#）', '301G', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (63, '2023-10L-2（3#）', '301H', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (64, '2023-10L-2（3#）', '301J', '2023-04-15 15:58:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (65, '2023-10L-3（3#）', '301K', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (66, '2023-10L-3（3#）', '301L', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (67, '2023-10L-3（3#）', '301M', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (68, '2023-10L-3（3#）', '301N', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (69, '2023-10L-3（3#）', '301P', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (70, '2023-10L-3（3#）', '301Q', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (71, '2023-10L-3（3#）', '301R', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (72, '2023-10L-3（3#）', '301S', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (73, '2023-10L-3（3#）', '301T', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (74, '2023-10L-3（3#）', '301V', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (75, '2023-10L-3（3#）', '301W', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (76, '2023-10L-3（3#）', '301X', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (77, '2023-10L-3（3#）', '301Y', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (78, '2023-10L-3（3#）', '3020', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (79, '2023-10L-3（3#）', '3021', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (80, '2023-10L-3（3#）', '3022', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (81, '2023-10L-3（3#）', '3023', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (82, '2023-10L-3（3#）', '3024', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (83, '2023-10L-3（3#）', '3025', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (84, '2023-10L-3（3#）', '3026', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (85, '2023-10L-3（3#）', '3027', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (86, '2023-10L-3（3#）', '3028', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (87, '2023-10L-3（3#）', '3029', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (88, '2023-10L-3（3#）', '302A', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (89, '2023-10L-3（3#）', '302B', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (90, '2023-10L-3（3#）', '302C', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (91, '2023-10L-3（3#）', '302D', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (92, '2023-10L-3（3#）', '302E', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (93, '2023-10L-3（3#）', '302F', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (94, '2023-10L-3（3#）', '302G', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (95, '2023-10L-3（3#）', '302H', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (96, '2023-10L-3（3#）', '302J', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (97, '2023-10L-3（3#）', '302K', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (98, '2023-10L-3（3#）', '302L', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (99, '2023-10L-3（3#）', '302M', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (100, '2023-10L-3（3#）', '302N', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (101, '2023-10L-3（3#）', '302P', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (102, '2023-10L-3（3#）', '302Q', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (103, '2023-10L-3（3#）', '302R', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (104, '2023-10L-3（3#）', '302S', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (105, '2023-10L-3（3#）', '302T', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (106, '2023-10L-3（3#）', '302V', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (107, '2023-10L-3（3#）', '302W', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (108, '2023-10L-3（3#）', '302X', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (109, '2023-10L-3（3#）', '302Y', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (110, '2023-10L-3（3#）', '3030', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (111, '2023-10L-3（3#）', '3031', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (112, '2023-10L-3（3#）', '3032', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (113, '2023-10L-3（3#）', '3033', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (114, '2023-10L-3（3#）', '3034', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (115, '2023-10L-3（3#）', '3035', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (116, '2023-10L-3（3#）', '3036', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (117, '2023-10L-3（3#）', '3037', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (118, '2023-10L-3（3#）', '3038', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (119, '2023-10L-3（3#）', '3039', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (120, '2023-10L-3（3#）', '303A', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (121, '2023-10L-3（3#）', '303B', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (122, '2023-10L-3（3#）', '303C', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (123, '2023-10L-3（3#）', '303D', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (124, '2023-10L-3（3#）', '303E', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (125, '2023-10L-3（3#）', '303F', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (126, '2023-10L-3（3#）', '303G', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (127, '2023-10L-3（3#）', '303H', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (128, '2023-10L-3（3#）', '303J', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (129, '2023-10L-3（3#）', '303K', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (130, '2023-10L-3（3#）', '303L', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (131, '2023-10L-3（3#）', '303M', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (132, '2023-10L-3（3#）', '303N', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (133, '2023-10L-3（3#）', '303P', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (134, '2023-10L-3（3#）', '303Q', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (135, '2023-10L-3（3#）', '303R', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (136, '2023-10L-3（3#）', '303S', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (137, '2023-10L-3（3#）', '303T', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (138, '2023-10L-3（3#）', '303V', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (139, '2023-10L-3（3#）', '303W', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (140, '2023-10L-3（3#）', '303X', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (141, '2023-10L-3（3#）', '303Y', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (142, '2023-10L-3（3#）', '3040', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (143, '2023-10L-3（3#）', '3041', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (144, '2023-10L-3（3#）', '3042', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (145, '2023-10L-3（3#）', '3043', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (146, '2023-10L-3（3#）', '3044', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (147, '2023-10L-3（3#）', '3045', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (148, '2023-10L-3（3#）', '3046', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (149, '2023-10L-3（3#）', '3047', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (150, '2023-10L-3（3#）', '3048', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (151, '2023-10L-3（3#）', '3049', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (152, '2023-10L-3（3#）', '304A', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (153, '2023-10L-3（3#）', '304B', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (154, '2023-10L-3（3#）', '304C', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (155, '2023-10L-3（3#）', '304D', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (156, '2023-10L-3（3#）', '304E', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (157, '2023-10L-3（3#）', '304F', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (158, '2023-10L-3（3#）', '304G', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (159, '2023-10L-3（3#）', '304H', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (160, '2023-10L-3（3#）', '304J', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (161, '2023-10L-3（3#）', '304K', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (162, '2023-10L-3（3#）', '304L', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (163, '2023-10L-3（3#）', '304M', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (164, '2023-10L-3（3#）', '304N', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (165, '2023-10L-3（3#）', '304P', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (166, '2023-10L-3（3#）', '304Q', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (167, '2023-10L-3（3#）', '304R', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (168, '2023-10L-3（3#）', '304S', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (169, '2023-10L-3（3#）', '304T', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (170, '2023-10L-3（3#）', '304V', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (171, '2023-10L-3（3#）', '304W', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (172, '2023-10L-3（3#）', '304X', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (173, '2023-10L-3（3#）', '304Y', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (174, '2023-10L-3（3#）', '3050', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (175, '2023-10L-3（3#）', '3051', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (176, '2023-10L-3（3#）', '3052', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (177, '2023-10L-3（3#）', '3053', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (178, '2023-10L-3（3#）', '3054', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (179, '2023-10L-3（3#）', '3055', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (180, '2023-10L-3（3#）', '3056', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (181, '2023-10L-3（3#）', '3057', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (182, '2023-10L-3（3#）', '3058', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (183, '2023-10L-3（3#）', '3059', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (184, '2023-10L-3（3#）', '305A', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (185, '2023-10L-3（3#）', '305B', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (186, '2023-10L-3（3#）', '305C', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (187, '2023-10L-3（3#）', '305D', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (188, '2023-10L-3（3#）', '305E', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (189, '2023-10L-3（3#）', '305F', '2023-04-15 16:24:41');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (190, '2023-10L-4（3#）', '305G', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (191, '2023-10L-4（3#）', '305H', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (192, '2023-10L-4（3#）', '305J', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (193, '2023-10L-4（3#）', '305K', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (194, '2023-10L-4（3#）', '305L', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (195, '2023-10L-4（3#）', '305M', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (196, '2023-10L-4（3#）', '305N', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (197, '2023-10L-4（3#）', '305P', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (198, '2023-10L-4（3#）', '305Q', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (199, '2023-10L-4（3#）', '305R', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (200, '2023-10L-4（3#）', '305S', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (201, '2023-10L-4（3#）', '305T', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (202, '2023-10L-4（3#）', '305V', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (203, '2023-10L-4（3#）', '305W', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (204, '2023-10L-4（3#）', '305X', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (205, '2023-10L-4（3#）', '305Y', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (206, '2023-10L-4（3#）', '3060', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (207, '2023-10L-4（3#）', '3061', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (208, '2023-10L-4（3#）', '3062', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (209, '2023-10L-4（3#）', '3063', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (210, '2023-10L-4（3#）', '3064', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (211, '2023-10L-4（3#）', '3065', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (212, '2023-10L-4（3#）', '3066', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (213, '2023-10L-4（3#）', '3067', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (214, '2023-10L-4（3#）', '3068', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (215, '2023-10L-4（3#）', '3069', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (216, '2023-10L-4（3#）', '306A', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (217, '2023-10L-4（3#）', '306B', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (218, '2023-10L-4（3#）', '306C', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (219, '2023-10L-4（3#）', '306D', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (220, '2023-10L-4（3#）', '306E', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (221, '2023-10L-4（3#）', '306F', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (222, '2023-10L-4（3#）', '306G', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (223, '2023-10L-4（3#）', '306H', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (224, '2023-10L-4（3#）', '306J', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (225, '2023-10L-4（3#）', '306K', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (226, '2023-10L-4（3#）', '306L', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (227, '2023-10L-4（3#）', '306M', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (228, '2023-10L-4（3#）', '306N', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (229, '2023-10L-4（3#）', '306P', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (230, '2023-10L-4（3#）', '306Q', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (231, '2023-10L-4（3#）', '306R', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (232, '2023-10L-4（3#）', '306S', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (233, '2023-10L-4（3#）', '306T', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (234, '2023-10L-4（3#）', '306V', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (235, '2023-10L-4（3#）', '306W', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (236, '2023-10L-4（3#）', '306X', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (237, '2023-10L-4（3#）', '306Y', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (238, '2023-10L-4（3#）', '3070', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (239, '2023-10L-4（3#）', '3071', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (240, '2023-10L-4（3#）', '3072', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (241, '2023-10L-4（3#）', '3073', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (242, '2023-10L-4（3#）', '3074', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (243, '2023-10L-4（3#）', '3075', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (244, '2023-10L-4（3#）', '3076', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (245, '2023-10L-4（3#）', '3077', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (246, '2023-10L-4（3#）', '3078', '2023-04-15 16:28:13');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (247, '2023-10L-5（3#）', '3079', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (248, '2023-10L-5（3#）', '307A', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (249, '2023-10L-5（3#）', '307B', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (250, '2023-10L-5（3#）', '307C', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (251, '2023-10L-5（3#）', '307D', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (252, '2023-10L-5（3#）', '307E', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (253, '2023-10L-5（3#）', '307F', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (254, '2023-10L-5（3#）', '307G', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (255, '2023-10L-5（3#）', '307H', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (256, '2023-10L-5（3#）', '307J', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (257, '2023-10L-5（3#）', '307K', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (258, '2023-10L-5（3#）', '307L', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (259, '2023-10L-5（3#）', '307M', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (260, '2023-10L-5（3#）', '307N', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (261, '2023-10L-5（3#）', '307P', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (262, '2023-10L-5（3#）', '307Q', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (263, '2023-10L-5（3#）', '307R', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (264, '2023-10L-5（3#）', '307S', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (265, '2023-10L-5（3#）', '307T', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (266, '2023-10L-5（3#）', '307V', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (267, '2023-10L-5（3#）', '307W', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (268, '2023-10L-5（3#）', '307X', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (269, '2023-10L-5（3#）', '307Y', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (270, '2023-10L-5（3#）', '3080', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (271, '2023-10L-5（3#）', '3081', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (272, '2023-10L-5（3#）', '3082', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (273, '2023-10L-5（3#）', '3083', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (274, '2023-10L-5（3#）', '3084', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (275, '2023-10L-5（3#）', '3085', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (276, '2023-10L-5（3#）', '3086', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (277, '2023-10L-5（3#）', '3087', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (278, '2023-10L-5（3#）', '3088', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (279, '2023-10L-5（3#）', '3089', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (280, '2023-10L-5（3#）', '308A', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (281, '2023-10L-5（3#）', '308B', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (282, '2023-10L-5（3#）', '308C', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (283, '2023-10L-5（3#）', '308D', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (284, '2023-10L-5（3#）', '308E', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (285, '2023-10L-5（3#）', '308F', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (286, '2023-10L-5（3#）', '308G', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (287, '2023-10L-5（3#）', '308H', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (288, '2023-10L-5（3#）', '308J', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (289, '2023-10L-5（3#）', '308K', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (290, '2023-10L-5（3#）', '308L', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (291, '2023-10L-5（3#）', '308M', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (292, '2023-10L-5（3#）', '308N', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (293, '2023-10L-5（3#）', '308P', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (294, '2023-10L-5（3#）', '308Q', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (295, '2023-10L-5（3#）', '308R', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (296, '2023-10L-5（3#）', '308S', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (297, '2023-10L-5（3#）', '308T', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (298, '2023-10L-5（3#）', '308V', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (299, '2023-10L-5（3#）', '308W', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (300, '2023-10L-5（3#）', '308X', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (301, '2023-10L-5（3#）', '308Y', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (302, '2023-10L-5（3#）', '3090', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (303, '2023-10L-5（3#）', '3091', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (304, '2023-10L-5（3#）', '3092', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (305, '2023-10L-5（3#）', '3093', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (306, '2023-10L-5（3#）', '3094', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (307, '2023-10L-5（3#）', '3095', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (308, '2023-10L-5（3#）', '3096', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (309, '2023-10L-5（3#）', '3097', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (310, '2023-10L-5（3#）', '3098', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (311, '2023-10L-5（3#）', '3099', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (312, '2023-10L-5（3#）', '309A', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (313, '2023-10L-5（3#）', '309B', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (314, '2023-10L-5（3#）', '309C', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (315, '2023-10L-5（3#）', '309D', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (316, '2023-10L-5（3#）', '309E', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (317, '2023-10L-5（3#）', '309F', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (318, '2023-10L-5（3#）', '309G', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (319, '2023-10L-5（3#）', '309H', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (320, '2023-10L-5（3#）', '309J', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (321, '2023-10L-5（3#）', '309K', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (322, '2023-10L-5（3#）', '309L', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (323, '2023-10L-5（3#）', '309M', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (324, '2023-10L-5（3#）', '309N', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (325, '2023-10L-5（3#）', '309P', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (326, '2023-10L-5（3#）', '309Q', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (327, '2023-10L-5（3#）', '309R', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (328, '2023-10L-5（3#）', '309S', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (329, '2023-10L-5（3#）', '309T', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (330, '2023-10L-5（3#）', '309V', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (331, '2023-10L-5（3#）', '309W', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (332, '2023-10L-5（3#）', '309X', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (333, '2023-10L-5（3#）', '309Y', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (334, '2023-10L-5（3#）', '30A0', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (335, '2023-10L-5（3#）', '30A1', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (336, '2023-10L-5（3#）', '30A2', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (337, '2023-10L-5（3#）', '30A3', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (338, '2023-10L-5（3#）', '30A4', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (339, '2023-10L-5（3#）', '30A5', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (340, '2023-10L-5（3#）', '30A6', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (341, '2023-10L-5（3#）', '30A7', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (342, '2023-10L-5（3#）', '30A8', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (343, '2023-10L-5（3#）', '30A9', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (344, '2023-10L-5（3#）', '30AA', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (345, '2023-10L-5（3#）', '30AB', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (346, '2023-10L-5（3#）', '30AC', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (347, '2023-10L-5（3#）', '30AD', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (348, '2023-10L-5（3#）', '30AE', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (349, '2023-10L-5（3#）', '30AF', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (350, '2023-10L-5（3#）', '30AG', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (351, '2023-10L-5（3#）', '30AH', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (352, '2023-10L-5（3#）', '30AJ', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (353, '2023-10L-5（3#）', '30AK', '2023-04-15 16:31:52');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (354, '2023-9L-5（3#）', '30AL', '2023-04-21 11:28:50');
INSERT INTO T_main (id, supply_no, code_no, date) VALUES (355, '2023-9L-5（3#）', '30AM', '2023-04-21 11:28:50');

2.2 焊接标签表（合并表）

创建表 T_merge ，脚本如下：

--
-- 由SQLiteStudio v3.3.3 产生的文件 周六 5月 13 17:58:47 2023
--
-- 文本编码：System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- 表：T_merge
DROP TABLE IF EXISTS T_merge;
CREATE TABLE T_merge (id INTEGER PRIMARY KEY ASC AUTOINCREMENT UNIQUE, first_code VARCHAR (20), second_code VARCHAR (20), code_no VARCHAR (20), supply_no VARCHAR (20), date VARCHAR (40));
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (1, '000Q', '000R', 'M0002', '', '2023-04-21 17:07:53');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (2, '306Q', '305P', 'M0003', '2023-10L-4（3#）', '2023-04-21 18:23:22');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (3, '306N', '305R', 'M0004', '2023-10L-4（3#）', '2023-04-21 18:25:25');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (4, '306Q', '305P', 'M0005', '2023-10L-4（3#）', '2023-04-21 19:31:39');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (5, '306N', '305R', 'M0006', '2023-10L-4（3#）', '2023-04-21 19:31:43');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (6, '306P', '3065', 'M0007', '2023-10L-4（3#）', '2023-04-21 19:31:46');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (7, '305Q', '305T', 'M0008', '2023-10L-4（3#）', '2023-04-21 19:31:49');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (8, '305K', '3071', 'M0009', '2023-10L-4（3#）', '2023-04-21 19:31:52');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (9, '305G', '306Y', 'M000A', '2023-10L-4（3#）', '2023-04-21 19:34:08');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (10, '3061', '3064', 'M000B', '2023-10L-4（3#）', '2023-04-21 19:34:12');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (11, '306R', '3070', 'M000C', '2023-10L-4（3#）', '2023-04-21 19:34:15');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (12, '3063', '3072', 'M000D', '2023-10L-4（3#）', '2023-04-21 19:34:18');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (13, '306M', '3073', 'M000E', '2023-10L-4（3#）', '2023-04-21 19:34:21');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (14, 'BC14', 'BC17', 'M000F', '', '2023-04-21 19:42:05');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (15, '305H', '305S', 'M000G', '2023-10L-4（3#）', '2023-04-21 19:42:10');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (16, '305J', '3062', 'M000H', '2023-10L-4（3#）', '2023-04-21 19:42:13');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (17, 'BC11', 'BC18', 'M000J', '', '2023-04-21 19:42:16');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (18, 'BC13', 'BC21', 'M000K', '', '2023-04-21 19:42:19');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (19, 'BC9', 'BC6', 'M000L', '', '2023-04-21 19:43:21');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (20, 'BC16', 'BC22', 'M000M', '', '2023-04-21 19:43:24');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (21, 'BC19', 'BC23', 'M000N', '', '2023-04-21 19:43:28');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (22, 'BC4', 'BC20', 'M000P', '', '2023-04-21 19:43:31');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (23, 'BC7', 'BC15', 'M000Q', '', '2023-04-21 19:43:34');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (24, 'BC3', 'BC24', 'M000R', '', '2023-04-21 19:44:42');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (25, 'BC1', 'BC8', 'M000S', '', '2023-04-21 19:44:45');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (26, 'BC2', 'BC5', 'M000T', '', '2023-04-21 19:44:48');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (27, 'BC10', 'BC12', 'M000V', '', '2023-04-21 19:44:52');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (28, 'BC19', 'BC23', 'M000W', '', '2023-04-21 19:44:55');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (29, 'BC11', 'BC18', 'M000X', '', '2023-04-21 19:45:41');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (30, 'BC6', 'BC9', 'M000Y', '', '2023-04-21 19:45:44');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (31, 'BC13', 'BC21', 'M0010', '', '2023-04-21 19:45:47');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (32, '303C', '303C', 'M0011', '2023-10L-3（3#）', '2023-04-23 10:14:19');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (33, '304A', '304A', 'M0012', '2023-10L-3（3#）', '2023-04-23 10:14:23');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (34, '302Q', '304V', 'M0013', '2023-10L-3（3#）', '2023-04-23 10:14:26');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (35, '303M', '304G', 'M0014', '2023-10L-3（3#）', '2023-04-23 10:14:29');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (36, '304W', '302P', 'M0015', '2023-10L-3（3#）', '2023-04-23 10:14:33');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (37, '302V', '302E', 'M0016', '2023-10L-3（3#）', '2023-04-23 10:29:20');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (38, '304C', '302W', 'M0017', '2023-10L-3（3#）', '2023-04-23 10:29:23');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (39, '303P', '303B', 'M0018', '2023-10L-3（3#）', '2023-04-23 10:29:27');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (40, '304A', '304H', 'M0019', '2023-10L-3（3#）', '2023-04-23 10:29:30');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (41, '303Q', '301X', 'M001A', '2023-10L-3（3#）', '2023-04-23 10:29:33');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (42, '3054', '3055', 'M001B', '2023-10L-3（3#）', '2023-04-23 10:32:25');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (43, '3026', '303A', 'M001C', '2023-10L-3（3#）', '2023-04-23 10:32:28');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (44, '3048', '302C', 'M001D', '2023-10L-3（3#）', '2023-04-23 10:32:31');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (45, '302R', '302Y', 'M001F', '2023-10L-3（3#）', '2023-04-23 10:32:38');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (46, '304B', '302F', 'M001G', '2023-10L-3（3#）', '2023-04-23 10:35:41');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (47, '302X', '301T', 'M001H', '2023-10L-3（3#）', '2023-04-23 10:35:45');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (48, '304E', '304X', 'M001J', '2023-10L-3（3#）', '2023-04-23 10:35:48');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (49, '302N', '303N', 'M001K', '2023-10L-3（3#）', '2023-04-23 10:35:51');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (50, '303L', '302D', 'M001L', '2023-10L-3（3#）', '2023-04-23 10:35:54');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (51, '302G', '3049', 'M001M', '2023-10L-3（3#）', '2023-04-23 10:37:20');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (52, '302L', '302T', 'M001N', '2023-10L-3（3#）', '2023-04-23 10:37:23');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (53, '302S', '304R', 'M001P', '2023-10L-3（3#）', '2023-04-23 10:37:27');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (54, '304P', '304Q', 'M001Q', '2023-10L-3（3#）', '2023-04-23 10:37:30');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (55, '304F', '302M', 'M001R', '2023-10L-3（3#）', '2023-04-23 10:48:39');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (56, '3025', '301W', 'M001S', '2023-10L-3（3#）', '2023-04-23 10:52:58');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (57, '305E', '3050', 'M001T', '2023-10L-3（3#）', '2023-04-24 12:13:10');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (58, '305L', '3046', 'M001V', '2023-10L-4（3#）', '2023-04-24 12:13:15');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (59, '3023', '303J', 'M001W', '2023-10L-3（3#）', '2023-04-24 12:13:18');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (60, '3035', '302B', 'M001X', '2023-10L-3（3#）', '2023-04-24 12:13:21');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (61, '3028', '305A', 'M001Y', '2023-10L-3（3#）', '2023-04-24 12:13:24');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (62, '303F', '304J', 'M0020', '2023-10L-3（3#）', '2023-04-24 12:15:59');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (63, '3053', '3022', 'M0021', '2023-10L-3（3#）', '2023-04-24 12:16:02');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (64, '3045', '304Y', 'M0022', '2023-10L-3（3#）', '2023-04-24 12:16:05');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (65, '304N', '3036', 'M0023', '2023-10L-3（3#）', '2023-04-24 12:16:08');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (66, '3027', '303E', 'M0024', '2023-10L-3（3#）', '2023-04-24 12:16:11');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (67, '303G', '3052', 'M0025', '2023-10L-3（3#）', '2023-04-24 12:55:51');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (68, '304L', '302J', 'M0026', '2023-10L-3（3#）', '2023-04-24 12:55:55');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (69, '303H', '3045', 'M0027', '2023-10L-3（3#）', '2023-04-24 12:55:58');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (70, '3047', '302H', 'M0028', '2023-10L-3（3#）', '2023-04-24 12:56:01');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (71, '3037', '302A', 'M0029', '2023-10L-3（3#）', '2023-04-24 13:28:29');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (72, '303K', '3024', 'M002C', '2023-10L-3（3#）', '2023-04-24 13:28:33');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (73, '3029', '301Y', 'M002D', '2023-10L-3（3#）', '2023-04-24 13:28:36');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (74, '304M', '304M', 'M002E', '2023-10L-3（3#）', '2023-04-24 13:30:17');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (75, '304KJ', '304K', 'M002F', '', '2023-04-24 13:30:20');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (76, '303D', '304T', 'M002G', '2023-10L-3（3#）', '2023-04-24 13:34:06');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (77, '3067', '306L', 'M002H', '2023-10L-4（3#）', '2023-04-24 13:54:20');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (78, '306D', '306E', 'M002J', '2023-10L-4（3#）', '2023-04-24 13:54:23');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (79, '306C', '3074', 'M002K', '2023-10L-4（3#）', '2023-04-24 13:54:27');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (80, '306J', '306K', 'M002L', '2023-10L-4（3#）', '2023-04-24 13:54:30');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (81, '3068', '306F', 'M002M', '2023-10L-4（3#）', '2023-04-24 13:54:33');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (82, '306T', '302K', 'M002N', '2023-10L-4（3#）', '2023-04-24 13:56:23');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (83, '3077', '306X', 'M002P', '2023-10L-4（3#）', '2023-04-24 13:56:27');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (84, '306S', '306G', 'M002Q', '2023-10L-4（3#）', '2023-04-24 13:56:30');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (85, '305Y', '3069', 'M002R', '2023-10L-4（3#）', '2023-04-24 13:56:33');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (86, '3019', '3010', 'M002S', '2023-10L-2（3#）', '2023-04-26 11:02:16');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (87, '3016', '3012', 'M002T', '2023-10L-2（3#）', '2023-04-26 11:02:20');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (88, '301E', '301H', 'M002V', '2023-10L-2（3#）', '2023-04-26 11:02:23');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (89, '3015', '3017', 'M002W', '2023-10L-2（3#）', '2023-04-26 11:02:27');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (90, '301C', '300L', 'M002X', '2023-10L-2（3#）', '2023-04-26 11:02:30');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (91, '3013', '301F', 'M002Y', '2023-10L-2（3#）', '2023-04-26 11:03:38');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (92, '301A', '300T', 'M0030', '2023-10L-2（3#）', '2023-04-26 11:03:41');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (93, '3040', '301D', 'M0031', '2023-10L-3（3#）', '2023-04-26 11:03:44');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (94, '303S', '301N', 'M0032', '2023-10L-3（3#）', '2023-04-26 11:03:48');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (95, '301L', '303Y', 'M0033', '2023-10L-3（3#）', '2023-04-26 11:03:51');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (96, '3042', '3043', 'M0034', '2023-10L-3（3#）', '2023-04-26 11:05:42');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (97, '3011', '3018', 'M0035', '2023-10L-2（3#）', '2023-04-26 11:05:45');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (98, '300K', '301B', 'M0036', '2023-10L-2（3#）', '2023-04-26 11:05:49');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (99, '3014', '300Y', 'M0037', '2023-10L-2（3#）', '2023-04-26 11:05:52');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (100, '306H', '305L', 'M0038', '2023-10L-4（3#）', '2023-04-26 11:27:41');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (101, '305N', '3076', 'M0039', '2023-10L-4（3#）', '2023-04-26 11:27:45');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (102, '301G', '301J', 'M003A', '2023-10L-2（3#）', '2023-04-26 11:27:48');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (103, '306V', '3060', 'M003B', '2023-10L-4（3#）', '2023-04-26 11:27:51');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (104, '305X', '305M', 'M003C', '2023-10L-4（3#）', '2023-04-26 11:27:55');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (105, '306B', '305W', 'M003D', '2023-10L-4（3#）', '2023-04-26 11:29:03');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (106, '306W', '3078', 'M003E', '2023-10L-4（3#）', '2023-04-26 11:29:06');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (107, '305V', '3075', 'M003F', '2023-10L-4（3#）', '2023-04-26 11:29:10');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (108, '300R', '3031', 'M003G', '2023-10L-2（3#）', '2023-04-26 11:29:13');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (109, '305B', '3021', 'M003H', '2023-10L-3（3#）', '2023-04-26 11:39:36');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (110, '301P', '305C', 'M003J', '2023-10L-3（3#）', '2023-04-26 11:39:40');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (111, '301M', '303W', 'M003K', '2023-10L-3（3#）', '2023-04-26 11:39:43');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (112, '3020', '301K', 'M003L', '2023-10L-3（3#）', '2023-04-26 11:39:46');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (113, '303R', '301Q', 'M003M', '2023-10L-3（3#）', '2023-04-26 12:28:04');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (114, '3057', '3034', 'M003N', '2023-10L-3（3#）', '2023-04-26 12:28:08');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (115, '303X', '303T', 'M003P', '2023-10L-3（3#）', '2023-04-26 12:28:12');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (116, '305F', '3030', 'M003Q', '2023-10L-3（3#）', '2023-04-26 12:28:15');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (117, '3058', '3041', 'M003R', '2023-10L-3（3#）', '2023-04-26 12:28:18');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (118, '3033', '301R', 'M003S', '2023-10L-3（3#）', '2023-04-26 12:29:06');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (119, '3032', '3056', 'M003T', '2023-10L-3（3#）', '2023-04-26 12:29:09');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (120, '3015', '3039', 'M003V', '2023-10L-2（3#）', '2023-04-26 12:29:12');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (121, '309K', '309A', 'M003W', '2023-10L-5（3#）', '2023-04-27 18:37:40');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (122, '307W', '307H', 'M003X', '2023-10L-5（3#）', '2023-04-27 18:37:47');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (123, '308K', '308L', 'M003Y', '2023-10L-5（3#）', '2023-04-27 18:37:52');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (124, '30A5', '309B', 'M0040', '2023-10L-5（3#）', '2023-04-27 18:37:57');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (125, '307A', '309B', 'M0041', '2023-10L-5（3#）', '2023-04-27 18:38:02');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (126, '308N', '30AE', 'M0042', '2023-10L-5（3#）', '2023-04-27 18:40:57');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (127, '30A9', '307X', 'M0043', '2023-10L-5（3#）', '2023-04-27 18:41:02');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (128, '307V', '309V', 'M0044', '2023-10L-5（3#）', '2023-04-27 18:41:08');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (129, '30A8', '309F', 'M0045', '2023-10L-5（3#）', '2023-04-27 18:41:13');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (130, '309G', '309J', 'M0046', '2023-10L-5（3#）', '2023-04-27 18:41:18');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (131, '307G', '3083', 'M0047', '2023-10L-5（3#）', '2023-04-27 18:42:47');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (132, '3082', '309C', 'M0048', '2023-10L-5（3#）', '2023-04-27 18:42:52');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (133, '308X', '30A0', 'M0049', '2023-10L-5（3#）', '2023-04-27 18:42:58');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (134, '309E', '3097', 'M004A', '2023-10L-5（3#）', '2023-04-27 18:43:03');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (135, '307S', '307L', 'M004B', '2023-10L-5（3#）', '2023-04-27 18:43:08');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (136, '307K', '3080', 'M004C', '2023-10L-5（3#）', '2023-04-27 19:28:21');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (137, '309V', '3081', 'M004D', '2023-10L-5（3#）', '2023-04-27 19:28:27');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (138, '309J', '307Y', 'M004E', '2023-10L-5（3#）', '2023-04-27 19:28:32');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (139, '309T', '309Y', 'M004F', '2023-10L-5（3#）', '2023-04-27 19:28:37');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (140, '308P', '30A6', 'M004G', '2023-10L-5（3#）', '2023-04-27 19:28:42');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (141, '309H', '307T', 'M004H', '2023-10L-5（3#）', '2023-04-27 19:29:36');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (142, '309P', '309D', 'M004J', '2023-10L-5（3#）', '2023-04-27 19:29:41');
INSERT INTO T_merge (id, first_code, second_code, code_no, supply_no, date) VALUES (143, '308M', '309X', 'M004K', '2023-10L-5（3#）', '2023-04-27 19:29:46');

-- 索引：sqlite_autoindex_T_merge_1
DROP INDEX IF EXISTS sqlite_autoindex_T_merge_1;
CREATE INDEX sqlite_autoindex_T_merge_1 ON T_merge (id COLLATE BINARY);

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;

三、用法总结

更新语句如下：

UPDATE
      T_merge
SET supply_no = (SELECT supply_no
                  FROM T_main
                  WHERE code_no = T_merge.first_code)
where EXISTS (SELECT supply_no
                  FROM T_main
                  WHERE code_no = T_merge.first_code)

执行结果：
在这里插入图片描述

花北城
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
Sqlite 数据库文件更新机制
10-30
Sqlite 数据库文件更新机制
sqlite3多表查询
PETER327447的博客
05-10 1410
tabel_A,tabel_B,tabel_C,tabel_D 四张表查询方法： selectD.device_uuid,D.track_switchfromtabel_A AINNERJOINtabel_B BONA.device_uuid=B.device_uuidINNERJOINtabel_C CONA.device_uuid=C.device_uuidINNERJOINtabel_D DONA.device_uuid=D.device_uuid; ...
sql三表连接查询 - 使用sqlite 演示
bcbobo21cn的专栏
09-01 3771
表； 人员表，职位表，部门表； 现在要做的是：列出所有人员，以及他们所属的部门和职位； 由于要列出tb_user中的每一条记录，需要用左连接查询。这里要连接3个表； 代码如下； SELECT u.sName,p.sCaption,d.sCaption FROM tb_user AS u LEFT JOIN (tb_pos AS p LEFT JOIN tb_dpt AS d ON p.id_Dpt=d.id) ON u.id_Pos=p.id; 运行； 提示 p.sCaption ，.
Android Sqlite数据库多表联合查询
尽此依报身，同生极乐国。
06-11 8329
Android Sqlite数据库多表联合查询 工作上用数据库存储文件还是很便利的，所以有时候发现一张表存储数据感觉数据结构不是很清晰的时候，就需要新加第二张表或者多张表来进行联合查询对象信，一般是用键将彼此联系起来，在表中，每个主键的值都是唯一的。这样做的目的是在不重复每个表中的所有数据的情况下，把表间的数据交叉捆绑在一起，下面，写一点简单的例子： 先说一下两张表各自要展现的内容有哪些 第...
面试常用SQLite 查询语句
开发者专栏
02-23 1267
1.查询A表的第10到20条记录select * from A limit 9 , 112.A表有id主键，name两个字段，插入一条数据（id = 1,name=”zhangsan”）要求，如果id为1不存在正常插入，如果存在则更新name值。replace table A (id,name) value (1,"zhangsan")3.A表表结构复制到B表中create table B as s
SQLite | Join 语句
侠的博客
03-06 1329
文章目录1. Join1.1 表联合1.2 内联合1.3 左联合1.4 其他联合类型1.5 多表联合1.6 分组联合参考资料 1. Join 我们在上一篇中介绍了 Case 语句 ，接下来我们将使用 join ，对表格进行合并。 使用Jupyter Notebook 运行 SQL 语句需安装 ipython-sql %sql 以及 %%sql 为在 Notebook 中运行 SQL 语句，...
日常学习 7.20 sqlite数据库的复杂查询
m0_57288002的博客
07-21 1172
select 表1.*，表2.字段名 where 表1.字段名=表2.字段名;重命名为：select * A.字段名,B.字段名 from 表1 A inner 表2 B on A.字段名=B.字段名;select * 表1.字段名,表2.字段名 from 表1 inner 表2 on 表1.字段名=表2.字段名;select * from 表1 inner join 表2 on 表1.字段名=表2.字段名;select * from 表1,表2 where 表1.字段名=表2.字段名;
SQLite下Update无法Join解决办法
jjhua的专栏
08-01 4485
SQLite下执行update语句无法像SQL Server下实现join，例如： update Product set Product.StockNumber =Product.StockNumber-BuyNumber from Product join OrderListDetail on (Product.ID =OrderListDetail.ProductID) joi
SQLite数据库 连表查询
m0_56051805的博客
05-14 1156
【SQLite数据库学习】 连表查询
Sqlite3联表更新的Sql语句
穿裤子的云
10-08 1116
Sqlite3不支持其他数据库中常见的联表更新语法，那么它有别的实现方法吗？
SQLite不支持Right Join的解决办法GROUP BY
09-14
sqlite真的不错，就是不支持right join，所以我们用下面的方法解决
Android实现SQLite添加、更新及删除行的方法
09-01
主要介绍了Android实现SQLite添加、更新及删除行的方法,涉及Android基于SQLiteDatabase类操作SQLite数据库的基本技巧,需要的朋友可以参考下
sqlite3 数据库更新
08-24
sqlite3的更新不同于一般的数据库更新， 它的跨表更新比较麻烦。这里是个例子。
sqlite表结构自动更新
08-06
继承自SQLiteOpenHelper 类，当数据库的数据或表结构有变动时，可以自动更新数据库，免去还得卸载程序，或者数据库更名的问题
MySQL安装教程（详细）
热门推荐
花北城的博客
07-28 20万+
第一个是强密码校验，mysql推荐使用最新的数据库和相关客户端，MySQL8换了加密插件，所以如果选第一种方式，很可能你的navicat等客户端连不上mysql8。那是缺少Microsoft Visual C++库的支持，跳转到首页，选择“默认安装类型”，它会自动检测，提醒你安装运行库支持。前面我们仅是安装好了数据库，我们实际使用的是应用软件（数据库中叫DBMS），需要再次安装管理软件，这里我选择SQLyong。输入完，点击next继续。64位操作系统，我选择【64-bit】，32位选【32-bit】
MySQL分类汇总(group by...with rollup)统计时，如何显示“总计”字段?
花北城的博客
03-09 3万+
使用grouping这个函数发现一直报错提示无法识别，仔细观察一下原来这是sql的语法，难道MySQL就实现不了了吗？没办法只得自己想办法了，我首先想到的方法是使用带条件的子查询，输出到最后一条数据时显示“总计”字段，但又嫌太复杂没有写。=”、“>”、“>=”、“
MySQL使用存储过程插入千万级数据如何提升效率？
花北城的博客
08-31 1万+
-- MySQL测试任务：使用存储过程，往表中插入千万级数据，根据索引优化速度 -- 1.使用索引查询 -- 2.不使用索引查 -- 3.比较两者查询速度的差异 -- 1.创建索引测试表 DROP TABLE IF EXISTS index_test; CREATE TABLE index_test( id BIGINT(20) PRIMARY KEY NOT NULL AU
【MySQL】数据表行列转换
花北城的博客
08-28 1万+
表行列转置，顾明思议，将表格中一行行的数据，采用SQL脚本转换成列数据。
【SQL】Excel数据导入速度太慢
花北城的博客
04-11 1万+
本专栏为【数据库】，主要介绍SQL的功能与特点、SQL数据定义语言（表、视图、索引、约束）、SQL数据操作语言（数据检索、数据插入、数据删除、数据更新）、创建与删除触发器、SQL数据控制语言（安全性和授权、事务处理）以及嵌入式SQL。如果你对本专辑感兴趣，持续关注吧。大家有任何问题，也可以评论区反馈，私信我。某个单价设置excel导入功能，时间很长，才400条数据，并且最后报错：该记录已存在。①　时间很长：代码里每导入一条数据，就会根据品名编码取一下产品信息，用来校验产品大类，这样。
sqlite leftjoin
最新发布
08-24
LEFT JOIN 是用于将两个表中的数据按照某个条件进行连接，同时保留左表中的所有记录。在 SQLite 中，LEFT JOIN 的语法如下： ```sql SELECT 列名 FROM 左表名 LEFT JOIN 右表名 ON 连接条件; ``` 其中，左表是指在 FROM 子句中出现的表，右表是指在 LEFT JOIN 子句中出现的表。连接条件是指用于连接两个表的条件。 举个例子，假设我们有两个表分别是 "users" 和 "orders"，并且它们之间有一个外键关联。我们想要获取所有的用户信息以及他们的订单信息（如果有的话）。可以使用以下 SQL 查询： ```sql SELECT users.name, orders.order_id, orders.order_date FROM users LEFT JOIN orders ON users.user_id = orders.user_id; ``` 这个查询将返回所有用户的姓名以及他们的订单信息。如果某个用户没有订单，那么对应的订单信息列就会显示为 NULL。 注意，上述示例仅为演示 LEFT JOIN 的基本用法，实际使用中可能需要根据业务需求进行相应的调整。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

花北城

你的鼓励是我最大的动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值