MySQL Forums
Forum List  »  MySQL Workbench

Load Data Not Working
Posted by: Mike Taylor
Date: February 14, 2011 10:16AM

Hi,
I just started using workbench and I can't get the load data command to work. Everytime I do it gives me the results

9874 Row(s) affected Records: 4937 Deleted: 4937

Why is deleting them after inserting??? I've never had this problem prior to using workbench.
Here is what I am using

load data local infile 'c:/Users/Mike/Desktop/bounced.csv'
replace into table optout.bounced
fields terminated by ','
enclosed by '"'
lines terminated by '\r\n'
(email);

Options: ReplyQuote


Subject
Views
Written By
Posted
Load Data Not Working
1499
February 14, 2011 10:16AM
537
February 15, 2011 02:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.