edit table in mysql code example
Example 1: how to edit table name in mysql
RENAME TABLE tb1 TO tb2;
Example 2: how to alter table column name in mysql
ALTER TABLE your_table_name RENAME COLUMN original_column_name TO new_column_name;
Example 3: alter table mysql
ALTER TABLE contacts
ADD last_name varchar(40) NOT NULL
AFTER contact_id,
ADD first_name varchar(35) NULL
AFTER last_name;