79286383

Date: 2024-12-17 00:08:15
Score: 1.5
Natty:
Report link

I'm posting just incase anyone had this question recently, as I have.

To change the datatype to accept something larger in Mysql, state the column name twice before implementing (in this case) the new larger datatype:

ALTER TABLE TableName 
CHANGE CurrentColumnName CurrentColumnName NewDataType;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Alysia Salaneck