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?

Accepted 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 - How to increase varchar size of an existing column in a database without breaking existing data?

Solution

Problem

Related problems