Re: AS link to MySQL?
Re: AS link to MySQL?
- Subject: Re: AS link to MySQL?
- From: webguide <email@hidden>
- Date: Fri, 29 Nov 2002 09:32:33 +1100
G'day Rob
>
Is there any way to drive the MySQL database server that's part of OS X
>
from AppleScript?
As the others have mentioned, use do shell script and fire away with
standard SQL commands which is how we update our MySQL web database.
We export a text file from FMP which has this weeks stuff, then run an AS
which opens the file in Tex-Edit, cleans it up (stupifys quotes etc), then
uses do shell script to import the file into the MySQL table. It works
remarkably well and we fire it from a youpi key timed event for unattended
operation.
There's a whole bunch of stuff you could do and I suppose you could even
wrap it all into an ASS project if you wanted simple interface. Mind you,
if you're looking for any sort of GUI then you should track down PHPMyAdmin
and install that.
cheers
kim
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.