update not insert?

General usage of Access to MySQL

Moderator: jr

Post Reply
muscle_tech
Posts: 5
Joined: Thu Jul 29, 2010 5:41 pm

update not insert?

Post by muscle_tech »

Hey guys every time it connects it drops all in restarts with the new..is it possivble that it can update and add whats missing?

un uncheck the fisrt box drop and recreat destination

but it still says creating tablexx in the comments when done
basementjack
Posts: 8
Joined: Tue Mar 30, 2010 8:48 pm

Re: update not insert?

Post by basementjack »

This is more of a programming issue.
for example bullzip won't know what data you have so it would not know what records to update vs insert.

You might be better off importing the whole table into a temp area in mysql, then doing an update query from the temp to the production.
using this method, you can also query changes (IE see all records being updated or see all records being added)
Post Reply