I have the following situation.
I get an csv file from an other application daily and put it in an
mysql DB, what is not a problem.
the csv has the following fields f.e. (it has many more and other, but
that is not relevant)
F1;F2
1;T1
2;T2
3;T2
In the mySQL DB I whant to put it in a table with additional fields,
where users can add additional informations.
F1;F2;A1;A2 (A1,A2 are the Field for the additional informations)
1;T1
2;T2
3;T3
But at the next day it is possible, that the CSV-File from the other
applikation has lines deleted and line added (which and how many lines
are added and deleted I dont know before)
How must I design my Tables and create my querys, that in the table
with aditional Field the records are deleted and added, so that I dont
have to compare each record of both tables in an programming language.
Thanks
Ralf
Received on Mon Jul 27 2009 - 16:05:16 CEST