[21S01][1136] Column count doesn't match value count at row 1
时间: 2023-10-20 12:31:56 浏览: 166
[21S01][1136]是MySQL数据库错误代码,意味着列数与值的数量不匹配。这种错误通常发生在插入或更新数据时,指定的列数与提供的值数量不一致。这可能是由于数据库表的列数与插入或更新语句中的列数不匹配导致的。要解决这个错误,您可以检查您的SQL语句,确保列名和值的数量是一致的,并且与表结构相匹配。如果问题仍然存在,您可能需要仔细检查您的数据和表结构,以确保它们是正确的。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [解决Mysql中出现的报错:ERROR 1136 (21S01): Column count doesn‘t match value count at row 1](https://blog.csdn.net/weixin_55987326/article/details/114654364)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [解决ERROR 1136 (21S01): Column count doesn‘t match value count at row 1](https://blog.csdn.net/HYZX_9987/article/details/130067069)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [TCL- AT21S135彩电特殊故障检修](https://download.csdn.net/download/weixin_38702515/14827679)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]
阅读全文