While deleting :Column count doesn't match value count at row 1

Question

I am trying to delete a row from a table but while deleting the entry, MySQL is giving me the following error:

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

the query which is i m executing is a simnple delete query:

DELETE from 'tablename' WHERE id=1341

Possible duplicate of [Column count doesn't match value count at row 1](http://stackoverflow.com/questions/18369252/column-count-doesnt-match-value-count-at-row-1) — MusicLovingIndianGirl, Jul 15 '16 at 12:24
Are there any triggers post delete. The error shouldn't occur for a delete I believe. — Sud, Jul 15 '16 at 12:39
Thanks Sud. There is a trigger which I ignored before. Now the query works fine — Prateek Bhati, Sep 28 '16 at 08:59

score 2 · Answer 1 · answered Mar 16 '19 at 21:20

2

Make sure you don't have any triggers on delete statement. You can see you triggers by SHOW TRIGGERS; AND if you want to drop one of the triggers DROP [name_of_the_trigger];

answered Mar 16 '19 at 21:20

Iurii

21
3

score 0 · Answer 2 · answered Jul 15 '16 at 13:32

0

DELETE from tablename WHERE id=1341

(without quotes) i guess is the correct answer

answered Jul 15 '16 at 13:32

Mark Roll

506
3
6
15

While deleting :Column count doesn't match value count at row 1

2 Answers2