Posted By

lyroge on 10/24/13


Tagged

mysql


Versions (?)

Drop and Add Column for Table of Mysql


 / Published in: MySQL
 

Drop and Add Column for Table of Mysql

  1. /* Add Column */
  2. ALTER TABLE [TableName] ADD COLUMN [ColumnName] VARCHAR(20);
  3.  
  4. /* Drop Column */
  5. ALTER TABLE [TableName] DROP [ColumnName];

Report this snippet  

You need to login to post a comment.