MySQL - How to increase varchar size of an existing column in a database without breaking existing data

Question

I have a column that is currently varchar 100  and I want to make it 10000   is it as simple as   alter table table name set column col name varchar  10000     I am afraid to corrupt the exiting data  Will I be ok if I run this query  Or should I do I alter the column another way   Thanks

User · Answer

For me worked this one   ALTER TABLE tablename MODIFY fieldname VARCHAR 128  NOT NULL

User · Answer

I d like explain the different alter table syntaxes - See the MySQL documentation  For adding removing defaults on a column   ALTER TABLE table name ALTER COLUMN col name  SET DEFAULT literal   DROP DEFAULT    For renaming a column  changing it s data type and optionally changing the column order   ALTER TABLE table name CHANGE  COLUMN  old col name new col name column definition  FIRST AFTER col name    For changing a column s data type and optionally changing the column order   ALTER TABLE table name MODIFY  COLUMN  col name column definition  FIRST   AFTER col name

User · Answer

For me this has worked-  ALTER TABLE table name ALTER COLUMN column name VARCHAR 50

User · Answer

I am using mysql and below syntax worked well for me   ALTER TABLE table name MODIFY col name VARCHAR 12

User · Answer

use this syntax  alter table table name modify column col name varchar  10000

User · Answer

It s safe to increase the size of your varchar column  You won t corrupt your data  If it helps your peace of mind  keep in mind  you can always run a database backup before altering your data structures  By the way  correct syntax is  ALTER TABLE table name MODIFY col name VARCHAR 10000   Also  if the column previously allowed did not allow nulls  you should add the appropriate syntax to the end of the alter table statement  after the column type

User · Answer

I normally use this statement   ALTER TABLE  table name    CHANGE COLUMN  col name   col name  VARCHAR 10000     But  I think SET will work too  never have tried it

[mysql] MySQL - How to increase varchar size of an existing column in a database without breaking existing data?

Examples related to mysql