Hi the team,

i would like to execute a mySQL under SQL Developper, but i do not achieve to do it.
With Oracle, it is quite simple doing:

DECLARE
BEGIN
INSERT ....
END;

But it does not work in mySQL.
I did not find any information about it.

Could you tell if it is possible to execute a mySQL script?

Thank you,
berni.

yes, it's possible to execute a "script"

please show exactly what you tried to execute, and the error message you got

i tried to insert this example:

DECLARE
BEGIN

INSERT MY_TABLE (field1, field2...) values (value1, value2...);

END;

I saw that we cannot do this with a mySQL DB.
We must pass through a file which contains these commands.

Is it true?

okay, could you please explain why you cannot just do the INSERT statement by itself? why do you need the DECLARE and BEGIN/END?

have a look at MySQL stored procedures. Although that would be overkill fro a simple inster statement

Hi guys and thank you for your help.

r937:
I would like to insert a lot of INSERT statement, that's why i needed a script.

healdem and r937:
contrary to Oracle, it appears that it is not possible to use a script (with DECLARE...BEGIN...END) in mySQL. Except using a file or a procedure.

Fanally, i did it using a procedure

Tahk you for your help.

Regards,
berni.