why am I getting a warning of Depreciation of INT(11) in latest version of MySQL?


Just because it is deprecated does not mean it won’t work.

Just don’t explicitly specify length anymore when creating new tables.

Let MySQL figure out how the length will be handled.

Personally, I never used the length operator in my years as a DBA. Besides, the length operator (11) simply stands for the display on a signed INT.

What is the range of a signed INT ??? -2147483648 to 2147483647. Please note that -2147483648 is 11 characters. That’s why 11 will appear in SHOW CREATE TABLE if you created the table without a length operator.

If you are concerned with how MySQL Workbench handled it, you may need to consider:

  • Upgrading to the latest version of MySQL Workbench
  • Switching to another up-to-date MySQL GUI

For now, the best thing is to run SHOW CREATE TABLE and ALTER TABLE commands without length operators. Let MySQL deprecation happen and don’t look back.