1. Computing

Modify - MySQL Command


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
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. Computing
    3. PHP / MySQL
    4. MySQL Commands
    5. Modify Column Size - MySQL Modify - SQL Modify