MySQL Increase Column Size

Examples

An example of modifying a MySQL table to increase a VARCHAR column size:

alter table TABLE_NAME modify COLUMN_NAME VARCHAR(1024) NOT NULL;

This increases COLUMN_NAME to 1024 characters.

No Comments

Leave a Reply

Allowed tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>