UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值
update es_gc_prod set prod_open_type='1' where prod_code='1012';
update es_gc_prod_attr set ipt_id = 'attachEndDate' where product_attr_id = '2017101112121018113';
更新多个字段:
UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'