I'm doing load data a few times a day via cron and using this:
LOAD DATA
LOCAL
INFILE '/file.txt'
INTO TABLE input
[...]
(@partnumb, description, price)
SET product_id=(SELECT product_id FROM products WHERE [EMAIL PROTECTED])
[...]
Now if the partnumber does NOT exists in the products table the product_id
gets the value 0 (zero). I would like to have it ignore if there is not
match, so i don't need to run a seperate query to delete everything with
product_id = 0.
Thanks in advance.
_________________________________________________________________
Hitta rätt på nätet med MSN Search http://search.msn.se/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
