At 21:45 -0700 10/14/03, Ooi Bee Sien wrote:
I'm running mySQL at windows XP and trying to include
couple of queries in a script file. The script file is
stored as "C:\myQuery.txt" and it is able to be
invoked successfully in a common way at mysql prompt.
mysql> \. C:\myQuery.txt
My question is, can I invoke the script file not from
the mysql prompt but through a client application
(written in VB)?
SOURCE and its synonym \. are mysql commands, not SQL
statements. As such, they are implemented internally
by the mysql client programs. To achieve this same
functionality in your application, you'll have to
open the file and process its contents yourself.
Are you MySQL certified? http://www.mysql.com/certification/
4 messages in com.mysql.lists.win32Re: Running Script File
