3
When making a call PROCEDURE
in SQL Fiddle, the following error is displayed:
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.
In the schema construction tab, I use the following query:
CREATE TABLE TEST( COD NUMERIC PRIMARY KEY UNIQUE,
DATESTART DATETIME,
DATEEND DATETIME);
INSERT INTO TEST
VALUES (1, '2019-03-29 10:20:57', '2019-04-29 10:20:57');
CREATE PROCEDURE PROC_TEST()
BEGIN
SELECT * FROM TEST;
END//
In the SQL execution tab:
CALL PROC_TEST()
Follows the fiddle used in the creation and call of PROCEDURE
.
Andre, could you come on chat to talk about this tag [tag:sqlfiddle]? It was very confusing these editions adding the tag.
– Woss
Hi @Andersoncarloswoss, I’m on chat.
– RXSD