mysql modify code example
Example 1: 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;
Example 2: my sql alter table
ALTER TABLE nom_table
MODIFY nom_colonne type_donnees
Example 3: my sql alter table
ALTER TABLE nom_table
DROP nom_colonne