-- SQLite数据导出到MySQL -- 导出时间: 2025-11-16 14:22:18 -- 禁用外键检查(如果需要) SET FOREIGN_KEY_CHECKS = 0; -- 清空表数据(可选,谨慎使用) -- TRUNCATE TABLE companies; -- TRUNCATE TABLE cargos; -- TRUNCATE TABLE purchase_plans; -- TRUNCATE TABLE weighing_slips; -- 公司表数据 INSERT INTO companies (name, created_at) VALUES ('安庆山峡化工', '2025-11-16 08:38:39'); INSERT INTO companies (name, created_at) VALUES ('安庆市山峡化工有限公司', '2025-11-16 09:50:43'); INSERT INTO companies (name, created_at) VALUES ('安庆伍六七', '2025-11-16 09:57:14'); INSERT INTO companies (name, created_at) VALUES ('安庆一二三', '2025-11-16 09:57:19'); INSERT INTO companies (name, created_at) VALUES ('测试公司', '2025-11-16 10:08:42'); -- 共 5 条公司记录 -- 货物表数据 INSERT INTO cargos (name, created_at) VALUES ('精致硫酸', '2025-11-16 08:38:45'); INSERT INTO cargos (name, created_at) VALUES ('工业硫酸 98%', '2025-11-16 09:54:58'); INSERT INTO cargos (name, created_at) VALUES ('工业硫酸 30%', '2025-11-16 09:55:45'); INSERT INTO cargos (name, created_at) VALUES ('工业硫酸 50%', '2025-11-16 09:55:51'); INSERT INTO cargos (name, created_at) VALUES ('氢氧化钠 32%', '2025-11-16 09:58:44'); INSERT INTO cargos (name, created_at) VALUES ('硫酸', '2025-11-16 10:00:07'); INSERT INTO cargos (name, created_at) VALUES ('盐酸', '2025-11-16 10:02:13'); INSERT INTO cargos (name, created_at) VALUES ('测试产品', '2025-11-16 10:08:42'); -- 共 8 条货物记录 -- 采购计划表数据