1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Modify - MySQL Command

By

A woman is working on her laptop
Alexander Klemm/E+/Getty Images
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 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.
Related Video
Create Bullet, Number, and Definition Lists in HTML
Top Related Searches
  • column name
    1. About.com
    2. Technology
    3. PHP / MySQL
    4. MySQL Commands
    5. Modify - MySQL Command (Definition and Examples)