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.

Code create error

zdma's profile image zdma posted 2 months ago in General Permalink

The value (22,0) is added to the DOUBLE field definition. In MySql, the definition of DOUBLE(22,0) means that the precision of the number is limited to 0 decimal places. Meanwhile, these values are not sent to the database when a new field is added and are transferred when the field is copied by the option "Copy selected columns".

ansgar's profile image ansgar posted 2 months ago Permalink

You should update to HeidiSQL's latest build, as I recently fixed some related stuff.

zdma's profile image zdma posted 1 month ago Permalink

Thanks. Now the Boolean field default value like 'b\'0\' doesn't work. During update the name of Boolean field with default value you obtain an exception...

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.
ansgar's profile image ansgar posted 1 month ago Permalink

Can you please post the exception's callstack here (can be stored by click on "save bugreport")

zdma's profile image zdma posted 1 month ago Permalink

ALTER TABLE app_users_views CHANGE COLUMN AUV_MAIN_VIEW AUV_MAIN_VIE BIT(1) NOT NULL DEFAULT 'b\'0\'' COMMENT 'Główny widok' AFTER AUV_GRID_SETTINGS; / Błąd SQL (1067): Invalid default value for 'AUV_MAIN_VIE' /

ansgar's profile image ansgar posted 1 month ago Permalink

I thought you meant an exception, but that's an SQL error here. However, I will have a look at that.

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