[thelist] SQL: finding "new" records in a table
Fred Jones
fredthejonester at gmail.com
Tue Sep 4 12:13:15 CDT 2007
>> I am no expert over here, but I would suggest that the only alternative
>> is of course to compare the records, that is the CSV record versus your
>> DB record, to see if an update is necessary or not.
>
> Agreed. My question then, is what is the most efficient way to do this?
> I could load the csv file into a temp table and then find all the rows
> that need inserts pretty easily via a join.
>
> What of the other rows though? What is the most efficient way to see if
> two rows are identical for 12 columns?
I would compare them in your code. I would use SQL to get the rows from
the DB, compare to the CSV data and then update if necessary.
Fredly
More information about the thelist
mailing list