Execute triggers stored procedures on SqlFiddle. Mysql
mysql, sqlfiddle
Solution
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.
Problem
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?