Re: [PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-10 Thread Bill Mudry
On Mon, May 10, 2010 at 7:03 AM, Bill Mudry <billmu...@rogers.com> wrote: I have seen many examples of just getting rid of duplicate records all in the same file. However, I need to know how to append one MySQL table into another table without adding duplicate

Re: [PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-10 Thread Bill Mudry
On Mon, May 10, 2010 at 7:03 AM, Bill Mudry <billmu...@rogers.com> wrote: I have seen many examples of just getting rid of duplicate records all in the same file. However, I need to know how to append one MySQL table into another table without adding duplicate

Re: [PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-10 Thread Ferenc Kovacs
On Mon, May 10, 2010 at 8:03 AM, Niel Archer wrote: > Hi > > As this is not a PHP question and in particular not Windows' related > PHP question, I'll keep my reply brief. > > If you had a unique index defined, duplicates wouldn't be allowed. Then > you would only have to add IGNORE to the INSERT

Re: [PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-09 Thread Niel Archer
Hi As this is not a PHP question and in particular not Windows' related PHP question, I'll keep my reply brief. If you had a unique index defined, duplicates wouldn't be allowed. Then you would only have to add IGNORE to the INSERT to prevent warnings being generated. http://dev.mysql.com/doc/ref

Re: [PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-09 Thread Ferenc Kovacs
On Mon, May 10, 2010 at 7:03 AM, Bill Mudry wrote: > I have seen many examples of just getting rid of duplicate records all in > the same file. > > However, I need to know how to append one MySQL table into another table > without > adding duplicate records into the original file accepting the da

[PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-09 Thread Bill Mudry
I have seen many examples of just getting rid of duplicate records all in the same file. However, I need to know how to append one MySQL table into another table without adding duplicate records into the original file accepting the data. I ran the following script that successfully appended d