Schema synchronization not working for data type integer length fields when blan

[Michael Flynn]

I removed the “length” from the INT data types in my local table using phpStorm [they used to be INT(10) but now they are just INT].

When I try to sync to my remote sever using the Schema Sync Tool the changes are shown but not made in the target table. They always default back to INT(11) so the tables are never in sync.

Please advise.

SQLYog Ultimate 13.1.7 (64 bit)

[Michael Flynn]

The interger datatype is deprecated in mySQL 8. How do I stop SQLyog from always applying it to my INT data types? My schema are never in sync because it seems SQLyog won’t accept a blank data length.

https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html

As of MySQL 8.0.17, the display width attribute is deprecated for integer data types; you should expect support for it to be removed in a future version of MySQL.

[Michael Flynn]

The integer datatype is deprecated in mySQL 8. How do I stop SQLyog from always applying it to my INT data types? My schema are never in sync because it seems SQLyog won’t accept a blank data length.

https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html

As of MySQL 8.0.17, the display width attribute is deprecated for integer data types; you should expect support for it to be removed in a future version of MySQL.

[Author]

Posts