xxxxxxxxxx
ALTER TABLE vendors ADD COLUMN phone VARCHAR(15) AFTER name;
xxxxxxxxxx
ALTER TABLE vendors ADD COLUMN phone VARCHAR(15) AFTER name;
xxxxxxxxxx
ALTER TABLE table ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];
xxxxxxxxxx
ALTER TABLE table
ADD [COLUMN] column_name column_definition
[FIRST|AFTER existing_column];
xxxxxxxxxx
ALTER TABLE table_name
MODIFY column_name column_definition
[ FIRST | AFTER column_name ];
xxxxxxxxxx
-- ALTER TABLE tbl_name ADD COLUMN column_name column_definition
-- [FIRST|AFTER existing_column];