insert into amc_repair.cancle_trans_repair_sheet2022 (sheet_num) values ('GX-004-500-220322-00514','GX-004-500-220322-00501','GX-004-500-220322-00489','GX-004-500-220322-00488','GX-004-500-220322-00486','GX-004-500-220322-00485','GX-004-500-220322-00483','GX-004-500-220322-00482','GX-004-500-220322-00481','GX-004-500-220322-00480','GX-004-500-220322-00476','GX-004-500-220322-00475','GX-004-500-220322-00474','GX-004-500-220322-00367','GX-004-500-220322-00365','GX-004-500-220322-00366','GX-004-500-220322-00356','GX-004-500-220322-00346','GX-004-500-220322-00333','GX-004-500-220322-00263','GX-004-500-220322-00241','GX-004-500-220322-00240','GX-004-500-220322-00239','GX-004-500-220322-00018','GX-004-500-220308-00039','GX-004-500-220308-00032','GX-004-500-220308-00025','GX-004-500-220308-00009','GX-004-500-220308-00008','GX-004-500-220308-00003','GX-004-500-220307-00090','GX-004-500-220307-00084','GX-004-500-220307-00059','GX-004-500-220307-00052','GX-004-500-220307-00049','GX-004-500-220113-00052','GX-004-500-220113-00050','GX-004-500-220113-00051','GX-004-500-220113-00049','GX-004-500-220113-00048','GX-004-500-220113-00043','GX-004-500-220113-00042','GX-004-500-220113-00033','GX-004-500-220113-00031','GX-004-500-220112-00047','GX-004-500-220112-00043','GX-004-500-220107-00055','GX-004-500-220107-00052','GX-004-500-220107-00050','GX-004-500-220107-00049','GX-004-500-220107-00048','GX-004-500-220107-00046','GX-004-500-220107-00047','GX-004-500-220107-00045','GX-004-500-220107-00044','GX-004-500-220107-00043','GX-004-500-220107-00039','GX-004-500-220107-00037','GX-004-500-220107-00036','GX-004-500-220107-00035','GX-004-500-220107-00034','GX-004-500-220107-00033','GX-004-500-220107-00031','GX-004-500-220107-00032','GX-004-500-220107-00028','GX-004-500-220107-00027','GX-004-500-220107-00026','GX-004-500-220107-00025','GX-004-500-220107-00022','GX-004-500-220107-00020','GX-004-500-220107-00019','GX-004-500-221215-00006') 提示 Column count doesn't match value count at row 1 是什么问题
时间: 2023-09-09 17:12:52 浏览: 104
doctor_echo_cancle.rar_DoAEC_canceller_doctor_echo_cancle_echo c
根据你提供的 SQL 语句,出现 "Column count doesn't match value count at row 1" 的错误提示是因为你在插入语句中指定了一个列(sheet_num),但是在 VALUES 子句中提供的值的数量与该列的数量不匹配。
根据你的 SQL 语句,你只指定了一个列(sheet_num),但是你提供了多个值。要解决这个问题,你需要确保 VALUES 子句中提供的值的数量与插入的列的数量匹配。
如果你想一次性插入多个行,那么你需要确保每一行都有相同数量的值,并且每个值按照列的顺序对应。
例如,如果你的目标是插入多个行,每个行都包含一个 sheet_num 值,你可以将插入语句修改为以下形式:
```sql
INSERT INTO amc_repair.cancle_trans_repair_sheet2022 (sheet_num) VALUES
('GX-004-500-220322-00514'),
('GX-004-500-220322-00501'),
('GX-004-500-220322-00489'),
...
('GX-004-500-221215-00006');
```
这样,每个 sheet_num 值都会被插入到对应的行中。请确保每个值都在单独的一行,并在每个值之间使用逗号分隔。
阅读全文