Skip to main content

Timeline for SQL Syntax error 1604 in CREATE PROCEDURE statement [duplicate]

Current License: CC BY-SA 4.0

11 events
when toggle format what by license comment
Jul 25, 2020 at 16:25 vote accept Teodor Maxim
Jul 20, 2020 at 22:47 history closed nbk
Bill Karwin mysql 		Duplicate of MySQL Syntax Error on DELIMITER before CREATE TRIGGER
Jul 20, 2020 at 18:51 answer added Teodor Maxim timeline score: 2
Jul 19, 2020 at 21:36 review Close votes
Jul 20, 2020 at 22:51
Jul 19, 2020 at 21:12 answer added Shantanu Kher timeline score: 0
Jul 19, 2020 at 20:38 comment added Teodor Maxim Tried it and it seems like there is a problem with the DELIMITER statement, as it gives me the same error on the next procedure I try to create.
Jul 19, 2020 at 20:34 comment added juergen d On the database you could just execute all that code at once. But using a framework try to execute only the procedure. No delimiter definition, no drop. just the procedure: CREATE PROCEDURE GetSessionID(IN token VARCHAR(64), OUT id INTEGER) BEGIN SELECT s.ID INTO id FROM Sessions AS s WHERE s.Token = token; END
Jul 19, 2020 at 20:29 comment added Teodor Maxim I tested the statements executing the DELIMITER, then the DROP, then the CREATE, and then the other DELIMITER statement in one go, using Goland's SQL runner. It works there, and the procedure exists on the database. Or do you mean something else by "at the same time"?
Jul 19, 2020 at 20:26 history edited Teodor Maxim CC BY-SA 4.0
Add details about my attempts at solving the problem and the tools I am using to execute queries.
Jul 19, 2020 at 20:24 comment added juergen d Since the error starts at the very beginning - there must be something wrong there. Do you try to execute 2 queries at the same time?
Jul 19, 2020 at 20:20 history asked Teodor Maxim CC BY-SA 4.0