Answers for "how to drop and add a column in one alter mysql"

mysql add column

ALTER TABLE table_name
ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];

Posted by: Guest on March-04-2020

alert table name mysql

ALTER TABLE exampletable RENAME TO new_table_name;

Posted by: Guest on October-04-2020

Code answers related to "how to drop and add a column in one alter mysql"