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 Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.