colinsp Posted February 28, 2009 Share Posted February 28, 2009 I have a database with a table of unique surnames. I have a csv file to import some more surnames into this table BUT there will be several surnames that are already in the db table. How do I do an import and ensure if the surname exists that it isn't added to the table? TIA -- Colin Link to comment https://forums.phpfreaks.com/topic/147301-noobie-how-can-i-import-csv-file-and-not-create-duplicates/ Share on other sites More sharing options...
fenway Posted February 28, 2009 Share Posted February 28, 2009 Depends if you have a unique index or not... if so, index ignore should work. Link to comment https://forums.phpfreaks.com/topic/147301-noobie-how-can-i-import-csv-file-and-not-create-duplicates/#findComment-773317 Share on other sites More sharing options...
colinsp Posted February 28, 2009 Author Share Posted February 28, 2009 Thanks I'll check that out. -- Colin Link to comment https://forums.phpfreaks.com/topic/147301-noobie-how-can-i-import-csv-file-and-not-create-duplicates/#findComment-773370 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.