So wich is the recomended way to import alot of data several times a day to mysql? I´m going to recive ~40 csv-files 3-4times a day which need to be imported. Each file contains around 10.000-50.000 items. My guess is to use LOAD DATA... BUT i only want to import the items with an ID- number that exists in an ID-number table. Please look at my example:
tbl_id-numbers-to-import 42145 75633 47743 89974 .... txt_csv-file 56745 item 44674 item 75633 item 89974 item 78563 item ... So i only want to import the items in the txt_csv-file with an ID-number that exists in the tbl_id-numbers-to-import. Thanks!! ------------------------------------------------- FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]