两表(多表)关联update（两表（多表）关联更新）.docVIP

两表(多表)关联update（两表（多表）关联更新） Table two (table update.txt28) associated with life of the elderly is a wise, life is a learned teacher, it often salutary influence of education, silent to guide us, give us inspiration in life. Do not spare your love, open your heart, give more, and you will find yourself bathed in the river of love. Two tables (multiple tables) associated with update -- connections only in the where sentence - this time the extracted data is VIP, and includes new ones, so by the way, update the customer category Update customers a -- using aliases Set customer_type=01--01 is VIP, 00 is average Where exists (select 1) From tmp_cust_city B Where b.customer_id=a.customer_id ) 3) two tables (multiple tables) associated with update - the modified values are computed by another table Update customers a -- using aliases Set city_name= (select b.city_name from tmp_cust_city b where b.customer_id=a.customer_id) Where exists (select 1) From tmp_cust_city B Where b.customer_id=a.customer_id ) - update more than 2 values Update customers a -- using aliases Set (city_name, customer_type) = (select, b.city_name, b.customer_type) From tmp_cust_city B Where b.customer_id=a.customer_id) Where exists (select 1) From tmp_cust_city B Where b.customer_id=a.customer_id ) Note in this statement, = (select, b.city_name, b.customer_type From tmp_cust_city B Where b.customer_id=a.customer_id ) and (select 1 From tmp_cust_city B Where b.customer_id=a.customer_id ) Two separate subquery, see execution plan, scan 2 for B table / index; If the where condition is discarded, the full table of the A table is by default Updated, but due to (select, b.city_name, from, tmp_cust_city, B, b.customer_id=a.customer_id, where, where, etc.) There is a possibility of not providing enough values because tmp_cust_city is only part of the customers information, So the error (if the column can be specified as --city_name NULL is another story): 01407, 00000, cannot, update (%s), to, NULL / / *Cause: