1,the original data is stored in the database as the image shows. the table is products.
2, the data in excel is as the following shows.
3,but when i open it by notepad++. it shows like this:
one: the data's format which i prepared is right? if not? how to correct it?
two: how to use joined update?
three: i using this command in phpmyadmin, supposed the csv file named test.csv. but the data doesn't be updated.
the command can run, but the data doesn't be updated. thank you.
LOAD DATA LOCAL INFILE 'D:\\test.csv' REPLACE INTO TABLE products
FIELDS TERMINATED BY ' '
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
SET products_price = IF(@var1 = '', 0, @var1); -- Replace empty string with 0