How to fix Warning: #1681 Integer display width is deprecated and will be removed in a future release.

[GubA]

When i import main.sql will show
Warning: #1681 Integer display width is deprecated and will be removed in a future release.

How to fix this.

Thank you.

[Emistry]

it shall be safe to ignore these kind of warning up to current version of MySQL 8.0+

If you'd like to avoid these warnings and play safe, update all your affected tables having column type definitions of something like INT(##) to INT (i.e. without explicitly specifying the display width)

[GubA]

3 hours ago, Emistry said:

it shall be safe to ignore these kind of warning up to current version of MySQL 8.0+

If you'd like to avoid these warnings and play safe, update all your affected tables having column type definitions of something like INT(##) to INT (i.e. without explicitly specifying the display width)

Thank you.

But.

How to update all your affected tables.

I use AppServ 9.3.0.

[Emistry]

ALTER TABLE <table_name> MODIFY <col_name> INT;

This will change the col_name's type to INT  (with default length)

[GubA]

Where is to change?