I'm using an old table, which has a varchar(40) field in it. I want it to be possible to insert more characters in that field, so I want to increase the length of it.
Are there possible negative consequences I should think of before increasing the length?
Increasing should typically not cause issues, it is the decreasing that can cause problems.
Changing the declared size of a varchar field should not require the existing data to be modified.
Note that changing the size of char or number field will require MySQL to update every affected value to the new type. Changing such fields or adding columns may result in the DBMS having to rewrite the entire table in order to accomodate a larger row size depending on whether there is any redundant space at the row level. This can take some time on a large table.
Make sure that you update any other tables which join to this column too!
HTH
C.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With