Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to change Column size of varchar type in mySQL? [duplicate]

Tags:

sql

mysql

I have the following table emp :

Field   Type       Null     Key     Default     Extra    id      int(11)     NO      PRI     NULL    auto_increment name    varchar(20) YES             NULL     dept    varchar(20) YES             NULL     

Now I like to change the varchar size of name from 20 to 50.

I have tried with the following SQL queries but the same error shows :

ALTER TABLE emp CHANGE COLUMN 'name' varchar(100);   ALTER TABLE emp ALTER  COLUMN name varchar(100); 

This is the ERROR :

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(100)' at line 2

Any idea how to change the column size of varchar type in MYSQL ?

like image 991
Zahid Rouf Avatar asked Mar 26 '14 16:03

Zahid Rouf


1 Answers

ALTER TABLE emp MODIFY COLUMN name VARCHAR(100); 

Or use CHANGE, but that means you have to give the column name twice (because CHANGE allows you to change the name of the column too).

ALTER TABLE emp CHANGE COLUMN name name VARCHAR(100); 

Don't put the column name in single-quotes. Single-quotes are for string literals or date literals.

like image 190
Bill Karwin Avatar answered Oct 11 '22 12:10

Bill Karwin