creating stored procedure - syntax error

Question

I keep getting a syntax error, I've look at countless examples I'm not sure what the problem is...

DELIMITER //
CREATE PROCEDURE test()
BEGIN
  SELECT *  FROM user;
END //
DELIMITER ;

SCREENSHOT:

There are 6 lines in your SQL code, what do you have on line 7? — mitkosoft
– mitkosoft, Commented May 3, 2016 at 8:53
@mitkosoft I have nothing underneath that no whitespace or anything... — Jordan Davis
– Jordan Davis, Commented May 3, 2016 at 8:54

Smita Ahinave · Accepted Answer · 2016-05-03 08:59:45Z

1

Alter procedure and remove delimiter....like below

CREATE PROCEDURE test()
BEGIN
  SELECT *  FROM user;
END

answered May 3, 2016 at 8:59

Smita Ahinave

1,8887 gold badges26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jordan Davis Over a year ago

I get a different error now - "Can't create a PROCEDURE from within another stored routine"

Avinash Mendse · Accepted Answer · 2016-05-03 09:13:19Z

0

Modify the user to [user] as user is reserved keyword

CREATE PROCEDURE test()
BEGIN
SELECT *  FROM [user];
END

answered May 3, 2016 at 9:13

Avinash Mendse

573 bronze badges

Comments

thephper · Accepted Answer · 2020-02-18 21:29:05Z

0

I experienced multiple problems when wanting to create a stored procedure in Navicat.

Finally I wrote the CREATE PROCEDURE-statement in the normal query window instead of inside the window to design a function/procedure, and then it worked.

answered Feb 18, 2020 at 21:29

thephper

2,70028 silver badges23 bronze badges

Collectives™ on Stack Overflow

creating stored procedure - syntax error

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related