GubA Posted January 25 Share Posted January 25 When i import main.sql will showWarning: #1681 Integer display width is deprecated and will be removed in a future release. How to fix this. Thank you. Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted January 26 Share Posted January 26 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) Quote Link to comment Share on other sites More sharing options...
0 GubA Posted January 26 Author Share Posted January 26 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. Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted January 26 Share Posted January 26 ALTER TABLE <table_name> MODIFY <col_name> INT; This will change the col_name's type to INT (with default length) Quote Link to comment Share on other sites More sharing options...
0 GubA Posted January 26 Author Share Posted January 26 Where is to change? Quote Link to comment Share on other sites More sharing options...
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.
Link to comment
Share on other sites