1. Home
  2. Computing & Technology
  3. PHP / MySQL

Modify - MySQL Command

By Angela Bradley, About.com

Definition: You can use the modify SQL command if you need to resize a column in MySQL. By doing this you can allow more or less characters than before. It is written as: alter table [table name] modify [column name] VARCHAR(5) ;
Also Known As: Modify Column, Resize Column
Examples:
alter table people modify name VARCHAR(35) ;
This changes the column called "name" on the table called "people" to now allow 35 characters.
Explore PHP / MySQL
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. MySQL Commands
  5. Modify Column Size - MySQL Modify - SQL Modify

©2009 About.com, a part of The New York Times Company.

All rights reserved.