用mysql执行shell命令,从MySQL执行Shell命令

I know what I'm looking for is probably a security hole, but since I managed to do it in Oracle and SQL Server, I'll give it a shot:

I'm looking for a way to execute a shell command from a SQL script on MySQL. It is possible to create and use a new stored procedure if necessary.

Notice: I'm not looking for the SYSTEM command which the mysql command line tool offers. Instead I'm looking for something like this:

BEGIN IF

COND1...

EXEC_OS cmd1; ELSE

EXEC_OS cmd2; END;

where EXEC_OS is the method to invocate my code.

解决方案

You might want to consider writing your scripts in a more featureful scripting language, like Perl, Python, PHP, or Ruby. All of these languages have libraries to run SQL queries.

There is no built-in method in the stored procedure language for running shell commands. This is considered a bad idea, not only because it's a security hole, but because any effects of shell commands do not obey transaction isolation or rollback, as do the effects of any SQL operations you do in the stored procedure:

START TRANSACTION;

CALL MyProcedure();

ROLLBACK;

If MyProcedure did anything like create or edit a file, or send an email, etc., those operations would not roll back.

I would recommend doing your SQL work in the stored procedure, and do other work in the application that calls the stored procedure.