Hello.
Have you seen comments at the bottom of: http://dev.mysql.com/doc/refman/5.0/en/load-data.html In my opinion, there are some solutions which should point you in the right direction, however I'm not sure if they're quick enough. Lindsey wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
