Command Line tool to run SQL statements?

[tonyyeb]

Hi all

I was wondering if there is a tool (which runs on Windows XP) where you can run it like the following:

mysqltool "SELECT * FROM table1" /u:myuser /p:my password /d:mydatabase /s:server.local (or ip address)

or an UPDATE, or INSERT etc....

And it return the result in the command window. I want to be able to run this command from any workstation and it not require anything to be installed (so the tol can run from the machine or a network drive etc...) and can be run as part of a windows batch file.

I created my own app that did this in VB .Net but it needed the MySQL ODBC driver installing on the client machine which I could do without really.

Any ideas?

Thanks

 

[tonyyeb]

Fine, then just ssh to the box and then run via cmd line.

Use putty if on windows.

Sorry not practical.

I have created my own tool in VB .Net now.