How can we write a query to join source table and target table with using columns from Lookups?
Type: Posts; User: srinu_vasrao; Keyword(s):
Lookup Query?
How can we write a query to join source table and target table with using columns from Lookups?
Re: Hi guys
Yes we can write update and insert in a single query like
insert into t1(a, b, c)
select d, e, f from t2
on duplicate key update b = e, c = f;
Use MySQL’s non-standard ON DUPLICATE KEY...