Surf 11 » Change size of a varchar column with mysql
Finding the best waves on the web.
October 17, 2005
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
- MySQL - SQL To Add a Column to a Table
- Alter Table Add Column on SQL Server
- MySQL Optimization Hints
- SELECT NULL Rows with MySQL
- My MySQL Backup Script
- MySQL vs Oracle vs PostgreSQL
- Free MySQL and PostgreSQL Hosting Accounts
- How To Check if MySQL Query Caching is Turned On
Comments
On at viney wrote:
1
thanks a lot man
On at manish wrote:
2
thanx a lot mann... u jus saved my life.
On at Racquel P. Tejano wrote:
3
This site is a big help....less words BUT very clear!
On at pravin wrote:
4
thnx yar the above soln solved my problem thnx again
- ASTsimpleVariableReference Error
- Alter Table Add Column on SQL Server
- Forward Unix Mail to Another Email Address
- Review of Vizio VW32LHDTV40A 32
- Howto List Contents of a Jar File
- Fixing SQL Server Users after Backup Restore
- Connect to SQL Server on Non Standard Port
- Ext s.gif Loading from extjs.com
Subscribe to our RSS Feed: 
XML
XML