更新列备注
alter table device_state modify column cmd int(11) not null default 0 comment '1)上传日志 2)上传数据库 3)重启应用 4)重启设备 5)清空数据库 6)开门';
查看列备注
show full columns from device_state;
同一个表select,update
update shop_goods sg, (select tmp1.id, tmp1.upc, tmp1.short_name from (select id,upc,short_name from shop_goods where shop_id=3598) tmp1) tmp set sg.short_name=tmp.short_name where sg.shop_id=5528 and sg.upc = tmp.upc;