How to merge new records from TABLE 1 to TABLE 2
-1
I have two MySQL tables: paalim and paalim_copy.
Table paalim_copy has some records from paalim, but also some new records. How can I merge these new records into paalim by using a MySQL UNIX command line?
The MySQL line which I tried (with Authorname Hackl, A. for example) is this:
insert into paalim VALUES
(Authorname,locQuery,eid,Affiliation,AffiliationINDEX,TabID,Moddate)
SELECT
b.Authorname,b.locQuery,b.eid,b.Affiliation,
b.AffiliationINDEX,b.TabID,b.Moddate
from paalim a left outer JOIN paalim_copy b on a.Authorname =
b.Authorname where (a.Authorname = 'Hackl, A.');
The problem is:
An outer join can not be used as all fields are available but new content.
I have a DOC ID EDI and an Authormane,
Can anyone here help me please?
Thanks