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 Link to comment https://forums.phpfreaks.com/topic/251655-display-ignored-datarows-from-data-import/ Share on other sites More sharing options...
fenway Posted November 23, 2011 Share Posted November 23, 2011 Why do you care? Link to comment https://forums.phpfreaks.com/topic/251655-display-ignored-datarows-from-data-import/#findComment-1290812 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.