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.

CHECK CONSTRAINTS and MySQL version 8.0.20

tonymarston's profile image tonymarston posted 1 month ago in Feature discussion Permalink

As of MySQL version 8.0.17 the use of the UNSIGNED attribute for float, double and decimal columns has been deprecated in favour of CHECK CONSTRAINTS. Although I can create such constraints they do not appear in the "CREATE code" tab nor when I export the table's structure. When I run the SHOW CREATE TABLE command in the SQL window this DOES show all these check constraints.

Why don't the CREATE TABLE scripts shown by HeidiSQL contain the same information from the SHOW CREATE TABLE command?

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.