Does SQL-fiddle facilitate execution of triggers/stored procedures?
I have been unable to execute even the simplest form of stored procedure on sqlfiddle
DELIMITER $$
DROP PROCEDURE IF EXISTS myProc $$
CREATE PROCEDURE myProc()
BEGIN
END$$
DELIMITER ;
Sqlfiddle does not allow executing this(above) sql in build schema, but allows create table etc
Note: The same syntax is working for me on my localhost using wamp with mysql 5.5.24
Can anyone guide please?
2条答案
按热度按时间goqiplq21#
Instead of using the delimiter option (which is not a real SQL statement, but rather only a command for the mysql command prompt) use the "Query Terminator" option on SQL Fiddle to establish your delimiter.
For example:
http://sqlfiddle.com/#!2/88fcf
Note the
//
dropdown below the schema box? That's the SQL Fiddle equivalent to the mysql DELIMITER command.Longer example with queries in the stored procedure (note that within the stored procedure,
;
is still used as a delimiter):http://sqlfiddle.com/#!9/4db78
Full disclosure: I'm the author of SQL Fiddle.
xmq68pz92#
I couldn't get this answer to work on sql fiddle, but found db-fiddle, and it seems to work.
Example in DB Fiddle
If the above doesn't work for some reason, do the following
SELECT * FROM tblTest;
on the right.