how to alter table column name in mysql
snippet in sql

how to alter table column name in mysql

user9151

ALTER TABLE your_table_name RENAME COLUMN original_column_name TO new_column_name;

alter table column in mysql

user9452


ALTER TABLE table_name

MODIFY column_name datatype; 

rename table column name in mysql

user7030

ALTER TABLE table_name CHANGE old_column_name new_column_name datatype(length);

alter table mysql

user4849

ALTER TABLE contacts
  ADD last_name varchar(40) NOT NULL
    AFTER contact_id,
  ADD first_name varchar(35) NULL
    AFTER last_name;