When I try to create a table with a column of type INT, it automatically gets allocated as INT(11) and this Int length will get depreciated in the latest version of MySQL. How can I declare the column as INT except of INT(11)?
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
What is the range of a signed
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.