Pages

Tuesday, January 12, 2016

add a column to a table in mysql

add a column to a table in mysql

How to add a column to a table in MySQL

ALTER TABLE table_name
MODIFY COLUMN column_name datatype

For Example,

ALTER TABLE os_uuid ADD ips  VARCHAR(255);
 


Reference:

http://www.w3schools.com/sql/sql_alter.asp

No comments:

Post a Comment