Experts Exchange connects you with the people and services you need so you can get back to work.
insert into table2 select customer_id, customer_name from table1 on duplicate key update customer_name = VALUES (customer_name)
Open in new window
create table temp as select table2.*,table1.customer_name from table2 inner join table1 on table1.customer_id = table2.customer_id
rename table2 to t , temp to table2
drop table t
Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
Update table2 a
inner join table1 b
on a. customerid = b.customerid
set a.customername = b.customername
Insert into table2 (customerid, customername)
select a.customerid, a.customername
from table1 a left join table2 b
on a.customerid = b.customerid
where b.customerid is null
table2 as a
Update KullaniciBilgileriiki a
inner join bayibilgileriiki b
on a.uid= b.uid
set a.isim = b.adi
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment