MySQL changes the table structure, changes the table data, and changes the column name.

Alter table uni_chn_f_cffex_if_201209_r.convertmaininfo_t0_tick add 'shouldcount 'bigint (20) not null after 'Count'

Modify Field:

Alter table trader_100122.16.tsncorder change cprice cmaxprice double not null;

Cprice-> cmaxprice

Alter table 'uploader _ 100'. tsncorder change 'cminprice' double after 'cpricetype ';

Change Field order

Update 'uni _ chn_f_cffex_if_201208_r '. 'convertinfo _ t0_tick' set 'infomation '= 'ctpfiltered' where 'infomation' = 'filtered ';
Update 'uni _ chn_f_cffex_if_201208_r '. 'convertinfo _ t0_tick 'set' varietycode' = 'if' where 'varietycode' = 'if ';
Update 'uni _ chn_f_cffex_if_201208_r '. 'convertinfo _ t0_tick' set 'source' = 'ctp _ t' where 'source' = 'ctp T ';

Alter table 'uni _ chn_f_cffex_if_201208_r '. 'convertinfo _ t0_tick 'rename to 'uni _ chn_f_cffex_if_201208_r'. 'convertdetailinfo _ t0_tick'

References:

Http://wocclyl.blog.163.com/blog/static/46223504200832304528326/