The alter of MySQL

1: Delete column ALTER TABLE "table name" DROP "column name" 2: Add column ALTER TABLE "table name" Add "column name" INT not NULL  COMMENT ' comment description ' 3: Modify column type information "ALTER TABLE" table name Word "Change" column Name "" New column name (you can use the same name as the original column) "BIGINT not NULL  COMMENT ' comment description ' 4: Rename column ALTER TABLE" table name "Change" column name "new column name" BIGINT N  OT NULL  COMMENT ' Note description ' 5: Rename table alter tables "table name" RENAME "Table new name" 6: Delete table primary key ALTER TABLE "table name" Drop primary Key7: Add primary key ALTER TABLE Sj_resource_charges add CONSTRAINT pk_sj_resource_charges PRIMARY KEY (resid,resfromid) 8: Add an index alter TABLE Sj_resource_ Charges add index index_name (NAME); 9: Add unique restriction index alter TABLE sj_resource_charges add unique emp_name2 (cardnumber); 10: Delete Cable Citation ALTER TABLE tablename DROP INDEX emp_name;

The alter of MySQL