MySQL Load Null Values from CSV data Error Code 1582

Question

I am trying to use the code seen in this example here:

I am using this code (Which works when I don't use the last three lines)

LOAD DATA LOCAL INFILE 'Myfiles/Products.csv'
INTO TABLE tblProducts
FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
LINES TERMINATED BY '\n'
(product_id, manufacturer, sku, pname, price, @vstock, @vcategory_id, lf_code)
Set 
stock = ifnull(@vstock = ''),
category_id = ifnull(@vcategory_id = '');

However, I keep getting the Error Code 1582: "Incorrect parameter count in the native function call 'ifnull' " Can someone explain what is going wrong?

ifnull(@vcategory_id,'')

e4c5
– e4c5

2016-08-18 01:56:10 +00:00
Commented Aug 18, 2016 at 1:56 — e4c5
– e4c5, Commented Aug 18, 2016 at 1:56
OMG LOL I just spent an hour trying to figure that out

Hound
– Hound

2016-08-18 01:56:56 +00:00
Commented Aug 18, 2016 at 1:56 — Hound
– Hound, Commented Aug 18, 2016 at 1:56

Barmar · Accepted Answer · 2016-08-18 01:58:52Z

1

You should beusing NULLIF(), not IFNULL(). It takes two arguments: an expression to return in the normal case, and something else to compare with it, and it returns NULL if they're equal. You don't write = between them.

stock = nullif(@vstock, ''),
category_id = nullif(@vcategory_id, '');

answered Aug 18, 2016 at 1:58

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Load Null Values from CSV data Error Code 1582

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related