List:MySQL on Win32« Previous MessageNext Message »
From:Dennis Thrysøe Date:November 16 1999 1:56pm
Subject:RE: Updating Mysql-database. Advices, hints?
View as plain text  
Perhaps the best thing would be writing a script that could connecto to bot
access and mysql?

Rhis could be done in Delphi with very few hassles.

-dennis

> -----Original Message-----
> From: Anders Engstrom [mailto:anders.engstrom.142@stripped]
> Sent: 16. november 1999 14:53
> To: win32@stripped
> Subject: 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.
>
>

Thread
Updating Mysql-database. Advices, hints?Anders Engstrom16 Nov
  • RE: Updating Mysql-database. Advices, hints?Dennis Thrysøe16 Nov
  • RE: Updating Mysql-database. Advices, hints?Alain Fontaine16 Nov
RE: Updating Mysql-database. Advices, hints?Anders Engstrom16 Nov
RE: Updating Mysql-database. Advices, hints?Anders Engstrom16 Nov
  • RE: Updating Mysql-database. Advices, hints?Alain Fontaine16 Nov
RE: Updating Mysql-database. Advices, hints?José Ostos Turner16 Nov