insert into 'budget_project_list' (id,project_list_name,business_line_code,is_owning_approve,summary,project_list_code,is_control,control_pattern,enable,create_by,modified_by,create_time,modified_time,version,dr,province_code) values ('30381020240001','铁塔成本','TXSC002','1','20240815上线导入','QDSC20240001','1','1',1,'hs_luojie@sc.cmcc','hs_luojie@sc.cmcc','2024-07-26 15:25:33.557','2024-07-26 15:25:33.557',0,1,'sc')

SQL 数据插入语句

• 基本语法：使用 INSERT INTO 语句将数据插入数据库表中。13
• 指定列名：可以指定要插入数据的列名，语法为 INSERT INTO table_name (列1, 列2, ...) VALUES (值1, 值2, ...)。36
• 错误处理：如果出现 Unknown column 'XX' in 'field list' 错误，可能是因为表中没有该列。7

具体操作

• 表名：budget_project_list
• 列名：id, project_list_name, business_line_code, is_owning_approve, summary, project_list_code, is_control, control_pattern, enable, create_by, modified_by, create_time, modified_time, version, dr, province_code
• 值：'30381020240001', '铁塔成本', 'TXSC002', '1', '20240815上线导入', 'QDSC20240001', '1', '1', 1, 'hs_luojie@sc.cmcc', 'hs_luojie@sc.cmcc', '2024-07-26 15:25:33.557', '2024-07-26 15:25:33.557', 0, 1, 'sc'

执行语句

INSERT INTO budget_project_list
(id, project_list_name, business_line_code, is_owning_approve, summary, project_list_code, is_control, control_pattern, enable, create_by, modified_by, create_time, modified_time, version, dr, province_code)
VALUES
('30381020240001', '铁塔成本', 'TXSC002', '1', '20240815上线导入', 'QDSC20240001', '1', '1', 1, 'hs_luojie@sc.cmcc', 'hs_luojie@sc.cmcc', '2024-07-26 15:25:33.557', '2024-07-26 15:25:33.557', 0, 1, 'sc');

确保表 budget_project_list 存在且列名与提供的值匹配，否则可能会遇到错误。7