update t_sales  set color1 = '黑色'  where color like '%黑%' ;
update t_sales  set color1 = '绿色'  where color like '%绿%' ;
update t_sales  set color1 = '红色'  where color like '%红%' ;
update t_sales  set color1 = '白色'  where color like '%白%' ;
update t_sales  set color1 = '蓝色'  where color like '%蓝%' ;
update t_sales  set color1 = '粉色'  where color like '%粉%'  and color1 is null ;
update t_sales  set color1 = '青色'  where color like '%青%' ;
update t_sales  set color1 = '卡其色'  where color like '%卡其%' ;
update t_sales  set color1 = '紫色'  where color like '%紫%' ;
update t_sales  set color1 = '肤色'  where color like '%肤%' ;
update t_sales  set color1 = '水晶虾'  where color like '%水晶虾%' ;
update t_sales  set color1 = '玫瑰色'  where color like '%玫瑰%' ;
update t_sales  set color1 = '银灰'  where color like '%银灰%' ;

update t_sales  set size1 = 'AA' where size like '%AA%'  ;
update t_sales  set size1 = 'A' where size like '%A%'  and size not like '%AA%'  ;
update t_sales  set size1 = 'B' where size like '%B%' ;
update t_sales  set size1 = 'C' where size like '%C%' ;
update t_sales  set size1 = 'D' where size like '%D%' ;
update t_sales  set size1 = 'E' where size like '%E%' ;
update t_sales  set size1 = 'F' where size like '%F%' ;
update t_sales  set size1 = 'G' where size like '%G%' ;

update t_sales  set size2 = '70'  where size like '%70%'  ;
update t_sales  set size2 = '75'  where size like '%75%'  ;
update t_sales  set size2 = '80'  where size like '%80%' ;
update t_sales  set size2 = '85'  where size like '%85%'  ;
update t_sales  set size2 = '90'  where size like '%90%'  ;
update t_sales  set size2 = '95'  where size like '%95%'  ;
update t_sales  set size2 = '100'  where size like '%100%'  ;
update t_sales  set size2 = '105'  where size like '%105%' ;
update t_sales  set size2 = '110'  where size like '%110%'  ;

delete from t_sales where size like '%S%';
delete from t_sales where size like '%X%';
delete from t_sales where size like '%M%';
delete from t_sales where size like '%L%';
delete from t_sales where color like '%S%';
delete from t_sales where color like '%X%';
delete from t_sales where color like '%M%';
delete from t_sales where color like '%L%';