How do I import data into mysql and tell mysql to only add new records or update just the changed records and leave the rest of the data the same.
Here is what I am trying to do. I currently use Telemagic as my database and have been for over 15 years. It is a property management business and I want to export just the properties that are available. I have the export part down. It’s just that when I import into mysql, the existing records do not update with new changes or new data.
It seems that I have to delete all the existing data and import all new records. If I do this, then the links to to pictures will get deleted too. I want those fields/links to stay the same, but only update if other data changes.
Does any of this make sense to anyone out there? I want to continue using Telemagic for my data because I also use it for wordprocessing/merging with hundreds of forms/letters used in the business. I don’t want to start all over and create a whole new database just to have dynamic data for the website.
I am extremely new to mysql, so any suggestions would be very much appreciated. Be kind!!!
Thanks in advance for any help!