var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Execute a script with mySQL
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:
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?
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:
INSERT MY_TABLE (field1, field2...) values (value1, value2...);
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
I'd rather be riding on the Tiger 800 or the Norton
Hi guys and thank you for your help.
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.