Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Copy as SQL INSERTs ignores hidden columns

ruyelpequenocid's profile image ruyelpequenocid posted 3 months ago in General Permalink

While certain columns are hidden from view, the Copy as SQL INSERTs operation fails to include those columns in the statement.

This results in a mismatch of columns when attempting to apply this INSERTs to an identical database that lives somewhere else.

The error shown is: SQL Error (1136): Column count doesn't match value count at row 1

Based on the images included with this post, you can see that if I have the column "Family" hidden from view and I perform the operation Copy as SQL INSERTs, I get:

INSERT INTO mammals VALUES (1, 'wolf');

But I had hoped there was a way to get all the columns, whether they are hidden or not:

INSERT INTO mammals VALUES (1, 'wolf', 'Canidae');

I think both scenarios are valid. I can see how creating a statement for the visible columns only is a good thing to have, but I think there should be an option that captures all columns as well, whether they are visible or not.

3 attachment(s):
  • 01
  • 02
  • error

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.