且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

删除查询 MySQL:列计数与第 1 行的值计数不匹配

更新时间:2022-12-10 22:18:04

该错误对于删除语句来说很奇​​怪.它很可能来***于删除而执行的写入错误的触发器.

That error is strange for a delete statement. It is most likely coming from badly written trigger that is being executed as a result of the delete.

此错误很可能会在如下所示的插入语句中遇到:

This error would most likely be encountered on an insert statement such as the following:

insert into foo(bar, baz)
select bar, baz, foobar, 2
from myTable

注意 insert 语句如何指定 2 列,但提供 4 个值.

Note how the insert statement specifies 2 columns, but provides 4 values.