17

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?

Sami
  • 7,844
  • 7
  • 62
  • 93

1 Answers1

46

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.

Karl Horky
  • 3,872
  • 29
  • 33
Jake Feasel
  • 16,359
  • 5
  • 50
  • 65
  • 9
    @JakeFeasel: let me take this opportunity to thank you once more for the AWESOME SQL Fiddle. You're the man! :| Keep rocking... – Leniel Maccaferri Nov 17 '12 at 03:08
  • 3
    @LenielMacaferi lol Thanks! Glad you like the site. Keep up the good work on the SQL questions! – Jake Feasel Nov 17 '12 at 05:10
  • 6
    See also [this bigger example, which shows that the queries IN the procedure actually need ; to delimit](http://sqlfiddle.com/#!2/e5a27/3). – Konerak Dec 02 '14 at 12:33
  • @Konerak thanks for that example, it was very helpful! – ocean800 Jun 11 '15 at 20:15
  • @Konerak looks like using MySQL 5.6 it stop to work and showing an error: DDL and DML statements are not allowed in the query panel for MySQL; only SELECT statements are allowed. Put DDL and DML in the schema panel . I'm using the example you sent http://sqlfiddle.com/#!2/e5a27/3 . there is another thread in Portuguese about it too https://pt.stackoverflow.com/questions/380029/erro-ao-realizar-chamada-de-procedure-no-sql-fiddle – Rafael Gorski May 04 '19 at 22:55