At 0:07 + 1/29/06, Jessica Svensson wrote:
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Jessica Svensson" <[EMAIL PROTECTED]>,mysql@lists.mysql.com
Subject: Re: LOAD DATA, Ignore in SET?
Date: Sat, 28 Jan 2006 17:59:23 -0600
At 23:42 + 1/28/06, Jessica Svensson wrote
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Jessica Svensson" <[EMAIL PROTECTED]>,mysql@lists.mysql.com
Subject: Re: LOAD DATA, Ignore in SET?
Date: Sat, 28 Jan 2006 17:59:23 -0600
At 23:42 + 1/28/06, Jessica Svensson wrote:
I'm doing load data a few times a
At 23:42 + 1/28/06, Jessica Svensson wrote:
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 part
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
