If I alter MySQL table column to increase size, will it delete data in the column?

Question

I have a varchar column that needs more space. How can I increase the size of the column (the number of characters it can have inserted into it), and not lose the data that is in there?

Thanks!

Check out this [StackOverflow post.](http://stackoverflow.com/questions/1279568/how-can-i-modify-a-size-of-column-in-a-mysql-table) — Milhous, Jul 19 '11 at 01:14

score 5 · Accepted Answer · answered Jul 19 '11 at 01:10

5

It won't delete the data by default.

answered Jul 19 '11 at 01:10

Edgar Velasquez Lim

2,426
18
15

Milhous has shared a link that'll show you as a comment on the question. – Edgar Velasquez Lim Jul 19 '11 at 01:25

score 2 · Answer 2 · answered Dec 26 '13 at 05:10

2

When you try to increase column size, it doesn't affect data. while decreasing column size, it should be affected

answered Dec 26 '13 at 05:10

php

4,307
1
24
13

If I alter MySQL table column to increase size, will it delete data in the column?

2 Answers2