MySQL SQL statement accumulation _mysql

--Renaming tables

Rename table T_softwareport to Software_port;

--Establish a foreign key

ALTER TABLE Software_port add constraint fk_software_port_softwareprocessid foreign key (SOFTWAREPROCESSID) references Software_process (ID) on the delete restrict on update restrict;

--Delete Column
ALTER TABLE software_type drop column upid, drop column OrderID;

--Modifying column names
ALTER TABLE software_process change software_id Softwareid Int (one) not null;

--Change column encoding

ALTER TABLE cms_contentbody Modify column offical_site_name varchar () Character Set UTF8 collate utf8_unicode_ci not nul L

--Adding columns

ALTER TABLE Cms_flash add name varchar is not NULL unique;