MySQL form shell()

[andu]

--On Monday, May 06, 2002 19:43:06 +0000 David Bovill 
<david.bovill at opn-technologies.com> wrote:

> OK the way I'm doing it at the moment is to pipe SQL from MC into MySQL
> using the shell() command - not sure if there is a better way but this
> works without having to use php or another intermediate scripting
> language.
>
> function executeSQL someSql, mySqlHost, userName, password
>   put "| mysql -h mySqlHost -u userName -p" & password into
> pipeToBatchMySQL   put "echo '" & someSQL & "'" && pipeToBatchMySQL into
> mySqlShellCommand   put shell(mySqlShellCommand) into buffer
>   return buffer
> end executeSQL
>
> Any comments on how to improve this appreciated.

That's how I would do it...

>
>
> _______________________________________________
> metacard mailing list
> metacard at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/metacard
>



Regards, Andu Novac