1681 Integer display width is deprecated and will be removed in a future release.
17:28:23 CREATE TABLE companies ( company_id varchar(255), company_name varchar(255), headquarters_phone_number int(12), primary key (company_id) ) 0 row(s) affected, 1 warning(s): 1681 Integer display width is deprecated and will be removed in a future release. 0.641 sec
Although the tables companies was created when I executed the commands I got the error above. what does it means and why
The commands that I typed are below:
CREATE TABLE companies
(
company_id varchar(255),
company_name varchar(255),
headquarters_phone_number int(12),
primary key (company_id)
);
Hi Maxime!
Great to have you in the course and thanks for reaching out!
Did you obtain an error message, or a warning? Also, what version of MySQL are you working on? Thank you.
Looking forward to your answer.
Best,
Martin
I am having the same problem. I got a warning message , and the version I am working on is 8.0.29.
the latest version of mysql. it is an error message
Hi Maxime and Saeed!
Thanks for reaching out.
What you obtain is just a warning message, not an error message. Therefore, you can currently proceed with the course smoothly.
Should any future update impede the smooth taking of the course, we will take action on our end (provide a note, update the video, or just reply in the Q&A - depends on the case).
Hope this helps.
Kind regards,
Martin