dunskii Posted November 23, 2011 Share Posted November 23, 2011 Hi All. I'm uploading a csv file into a table and am ignoring data that is duplicated Just wondering if anyone know the easiest/best way to display the data/rows that were ignored. I've had quick read and thought that mysql_info may do the job, but it will only display the number of rows that were duplicates. Heres my query mysql_query("LOAD DATA LOCAL INFILE '{$_FILES['contacts']['tmp_name']}' IGNORE INTO TABLE `batch_contacts` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'"); Thanks in advance. D MySQL Server version: 5.0.92-community Quote Link to comment Share on other sites More sharing options...
fenway Posted November 23, 2011 Share Posted November 23, 2011 Why do you care? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.