xjx424 Posted February 14, 2011 Share Posted February 14, 2011 Hi,I just started using workbench and I can't get the load data command to work. Every time I try it gives me the results9874 Row(s) affected Records: 4937 Deleted: 4937Why is deleting them after inserting??? I've never had this problem prior to using workbench.Here is what I am usingload data local infile 'c:/Users/Mike/Desktop/bounced.csv'replace into table optout.bouncedfields terminated by ','enclosed by '"'lines terminated by '\r\n'(email); Link to comment Share on other sites More sharing options...
boen_robot Posted February 14, 2011 Share Posted February 14, 2011 From where did you even triggered this option? I know MySQL Workbench can open SQL scripts, as well as generate ones, but to import csv files... why did you used csv anyway? Link to comment Share on other sites More sharing options...
xjx424 Posted February 14, 2011 Author Share Posted February 14, 2011 i was just importing data from CSV. I figured out my problem, when setting up the table the id column wasn't set as an index. I'm still adjusting to using workbench (which sucks IMO) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.