Advanced Search

Drop and Add Column for Table of Mysql

/ Published in: MySQL
Save to your folder(s)
Drop and Add Column for Table of Mysql

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.