[thelist] MySQL: importing non-duplicate records

Canfield, Joel JCanfield at PacAdvantage.org
Thu May 11 09:08:18 CDT 2006


our call detail database for the phone system has a programmatic limit
of 100K records on the cdr table. our net admin is working on automating
the export process to give me a dump of the data every day.

what's my best method for importing just the new records? i'm thinking
up all kinds of complex schemes. seems like mysql has this ability built
in, but my memory's failing me.

any advice/suggestions?

thanks

spinhead



More information about the thelist mailing list