Hello, we have two tables associated with a foreign key constraint. Table A with the primary key and table B with an "on delete cascade" constraint. We want to delete datasets in Table B if the related dataset in Table A is deleted - that works.
Now the Problem: There is a weekly import defined on table A using a "load data infile <FILE> replace into table A" command. The problem is the implicit delete/insert from the replace keyword. Therefore the sets in Table B are deleted. We are using replace because some datasets have to be modified in some columns in table A. Is there a possibility to avoid the delete in Table B by importing data in Table A? Regards, Spiker -- Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
