To add a column in terminal just enter this command. Change the values for customization.
ALTER TABLE [table] ADD COLUMN [column] VARCHAR(120);
To Add A column with a unique auto increment id use this.
ALTER TABLE [table] ADD COLUMN [column] int NOT NULL AUTO_INCREMENT PRIMARY KEY;
Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
Please follow and like us:
Add A Column MySql Terminal Command was last modified: December 12th, 2016 by