How to send a mysql script from QT application?

[ChrisW67]

There are two issues I can see:

1. QSqlQuery::exec() executes a single SQL statement and you are trying to pass two (DROP and CREATE PROCEDURE BEGIN ... END)
2. The DELIMITER lines are not SQL, they are directives to the mysql commandline tool to ensure it passes the whole procedure in one block rather than stopping at the first semicolon. The Mysql command line tool is not involved here.

You should be able to execute the DROP in one exec() call, and the CREATE PROCEDURE (with the internal semicolons as-is) in a second. If you are trying to handle a user-provided script with Mysql command line tool syntax then:

• you need to write a simple parser to split the script into statement and send them one at at time
• you need to really trust your user not to bork your database

[Ahmed Abdellatif]

I know it is too late, but thanks a lot.
smallcorrection:
into statement should be into 2 statements