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.

Can't create a cpy of table with bit fields

geoffschultz's profile image geoffschultz posted 1 month ago in General Permalink

I have a table with bit fields in it. When I right-click on the table and do a Create New -> Table Copy, I get the error: "SQL error (1067): Invalid default value for field xyz". The default value is b'1'.

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.