Surf 11 » Change size of a varchar column with mysql

Finding the best waves on the web.

You can use the ALTER TABLE command to change the size of a column. Suppose you want to change the size of a varchar column from 50 character to 100 characters, simply run the following SQL statement:

ALTER TABLE tablename MODIFY columnname varchar(100);


Related Entries
Name:

Email: (optional, not displayed on site)
   Subscribe to this thread
Comments: (html will be escaped)



Subscribe to our RSS Feed: subscribe to this feed XML
Archives   Tags   Contact