update not insert?

General usage of Access to MySQL

Moderator: jr

update not insert?

Postby muscle_tech » Sun Aug 01, 2010 4:10 pm

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
muscle_tech
 
Posts: 5
Joined: Thu Jul 29, 2010 5:41 pm

Re: update not insert?

Postby basementjack » Fri Oct 08, 2010 6:32 am

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)
basementjack
 
Posts: 8
Joined: Tue Mar 30, 2010 8:48 pm


Return to General

Who is online

Users browsing this forum: No registered users and 2 guests