Mysql adds columns, modifies column names and column attributes, and deletes column statements.

Mysql adds columns, modifies column names and column attributes, deletes column statements mysql modifies table names, column names, column types, adds columns, and deletes alter table test rename test1; -- modify the table name alter table test add column name varchar (10); -- add the table column www.2cto.com alter table test drop column name; -- delete the table column alter table test modify address char (10) -- modify the table column type | alter table test change address char (40) alter table test change column address address1 varchar (30) -- modify the table column name author charlesdong1989