错误1136:列计数与第1行的值计数不匹配 [英] ERROR 1136: Column count doesn't match value count at row 1

问题描述

我收到错误消息:

Column count doesn't match value count at row 1.

但是我已经检查并重新检查了我的查询，一切似乎都很好:

But I've checked and rechecked my query and everything seems ok:

UPDATE
    table
SET
    col = 'enum(''FOO'',''BAR'')'
WHERE
    col1 = ''
AND
    col2 = 'val2'
AND
    col3 = 3;

我认为表可能包含一些引发错误的触发器-我没有设计系统-但找不到任何触发器.

I thought the table could have some triggers that were generating the error –I didn't design the system– but I can't find any.

我在至少三个不同的表中发现了相同的错误.

I've found the same error with at least three different tables.

注意.第三行上的枚举"实际上应该是字符串，而不是枚举类型.

Note. The "enum" on line three is really supposed to be a string, not an enum type.

推荐答案

显然有一些触发器更新了另一个数据库，我不知道为什么show triggers from <dbname>返回空行集.

Apparently there were some triggers that updated another database, I don't know why show triggers from <dbname> returned an empty row set.

显然，在迁移系统时，他们必须寻求支持才能为其创建触发器.

Apparently, when migrating their system, they had to ask support to create the triggers for them.

这篇关于错误1136:列计数与第1行的值计数不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！