分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
1. update (select .....) set column1 = column2;
update (select iy.company_name company_name1, cc.company_name_jc company_name2
from income_year_item iy , city_company cc
where iy.company_code = cc.code
)
set company_name1 = company_name2;
2.只能单行子查询s
update CITY_PROJECT_SCALE_INFO c set
(c.value) = (
select d.value from CITY_PROJECT_SCALE_INFO @test d where d.project_id = '7d7fd580a06240b2a9137dc2bbe831e9'
and d.project_id = c.project_id and c.company_code = d.company_code
)
where exists (