Oracle update语句

版权声明:转载请注明出处 https://blog.csdn.net/DuanLiuchang/article/details/78247250


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'




展开阅读全文

没有更多推荐了,返回首页