Execute a shell command inside SQL

[tofuTnT]

Hi,

I wonder if there is anyway you can run a shell command inside SQL.
for example "SELECT * FROM table;execute shell command"
I had googled around and didn't find anything.

Regards,
tofuTnT

 

[TonyGroves]

No. Definitely not. Sorry.

 

[Bastien]

Geez, that wouldn't be a big security hole now would it?

Bastien

Cat, the other other white meat

 

[tofuTnT]

Well, from what I searched on the internet, MSSQL has a stored procedure xp_cmdshell that does just that.
example:
exec master.dbo.xp_cmdshell 'copy c:\temp\doesnotexist.txt c:\temp\workfile.txt'

so i wonder if there something similar in MySQL.

Regards,
tofuTnT