Hello,
How about this: create a couple of update queries, or "delete and insert"
pair queries, in Access, and use ODBC to directly update your mySQL tables?
You shouldn't need to recreate indexes and "not null" stuff as the mySQL
table definition and structure will never alter; the only thing that will
alter is its contents.
Maybe I got your question wrong... ? ;)
-----Message d'origine-----
De : Anders Engstrom [mailto:anders.engstrom.142@stripped]
Envoyé : mardi 16 novembre 1999 14:53
À : win32@stripped
Objet : Updating Mysql-database. Advices, hints?
Hi!
I'm using mysql-win32 v. 3.22.26a as the main data source for an
internet map server.
The information in the databases are primarily updated through a bunch
of Delphi interfaces - and this works fine.
I have one table, though, that i'm having trouble finding a suitable
update method for...
The table is app. 25.000 records, and when it is to be updated, all the
data will have to be replaced.
The data originally comes from a local MS Access database.
What i have been doing up to now is to take down the map server, move
the table to a different name, then importing the data from MS Access
using ODBC. After this I alter the table manually by setting indexes,
"not-nulling" different fields etc.
Now - I'll be leaving this project pretty soon, and the update
procedure will be taken over by someone else. I'm trying to make it as
easy as possible to update the database, but I'm not sure that the
above procedure is the best in this case. I would like it a bit more
automated, I guess.
Does anyone have any ideas, advices etc. that could help me find the
best way to update this table?
Best Regards /Anders
--
Anders Engström
GIS-Centrum, Lund
0709-62 07 73
=============================
Your mind's like an umbrella.
It doesn't work unless you open it.
/Frank Zappa
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread955@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@stripped instead.
