[MySQL] How To Add/Modify/Remove Columns From a Table

on

SELECT * FROM myTable;

ALTER TABLE myTable
ADD COLUMN myNewColumn VARCHAR(10) AFTER finalColumn;

ALTER TABLE myTable
MODIFY COLUMN myNewColumn VARCHAR(99);

ALTER TABLE myTable
DROP COLUMN myNewColumn;


Comments

Post a Comment