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.

Error while creating new tables, alter tables, table copies etc. (mysql/mariadb)

CoolWater's profile image CoolWater posted 7 months ago in General Permalink

There is an error while creating new tables, alter tables, table copies etc:

The quotation marks are missing for default values. I.E.:

ALTER TABLE table CHANGE COLUMN Column ColumnNew VARCHAR(255) NOT NULL DEFAULT COLLATE 'latin1_german2_ci' AFTER ColumnPrev;

This should be (emtpy default value):

ALTER TABLE table CHANGE COLUMN Column ColumnNew VARCHAR(255) NOT NULL DEFAULT "" COLLATE 'latin1_german2_ci' AFTER ColumnPrev;

HTH CoolWater

ansgar's profile image ansgar posted 7 months ago Permalink

Please report your used HeidiSQL version.

The latest builds may surely throw such errors, as I am working on a larger code change. In case you use a build, I can currently recommend not to use them, use the last stable release instead.

CoolWater's profile image CoolWater posted 7 months ago Permalink

My HeidiSQL version is 10.3.0.5811

I will revert back to the lastest stable release in this case... :-)

Regards CoolWater

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.