sammenkøre to databaser

Du kunne gøre det nemt, ved at lave email i tabel 2 unique.
Så vil mysql smide en fejl, hvis den allerede findes.
Ved insert kan du så bruge ignore og den vil blot hoppe den over.

tabel har faktisk uniqu ved email - hvordan bruges ignore i en insert?

Søren

Se her: http://dev.mysql.com/doc/refman/5.0/en/insert.html

Og du bruge ignore i din insert som følger:

INSERT IGNORE INTO
og "normalt" laver du nok bare:
INSERT INTO

IGNORE: If you use the IGNORE keyword, errors that occur while executing the INSERT  statement are treated as warnings instead. For example, without IGNORE, a row that duplicates an existing UNIQUE index or PRIMARY KEY value in the table causes a duplicate-key error and the statement is aborted. With IGNORE, the row still is not inserted, but no error is issued. Data conversions that would trigger errors abort the statement if IGNORE is not specified. With IGNORE, invalid values are adjusted to the closest values and inserted; warnings are produced but the statement does not abort. You can determine with the mysql_info() C API function how many rows were actually inserted into the table.

min udbyder ikker noget længere end til mysql 4.1.x  - det ser ud til at ignor kun kan bruges i 5.x??

http://dev.mysql.com/doc/refman/4.1/en/insert.html

takker nu spiller det

Søren

Super og takker for point.