Sql Syntax Error, on CREATE PROCEDURE

Question

Work with mysql on phpMyAdmin

SQL :

drop PROCEDURE if EXISTS mi;

CREATE PROCEDURE mi()  //<-- line 3
BEGIN
  INSERT INTO User ( `name` , `password` ) VALUES ('value1', 'value2');
  SET out_param = LAST_INSERT_ID();
END

CALL mi();

the 'drop' is for multi testing

we have table User there are id primary key , name varchar, password varchar

Error :

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3

thanks for any help !

add "delimiter $$"before create statement and "$$" after end statement, — Fahad Anjum
– Fahad Anjum, Commented Jun 2, 2017 at 18:33

Fahad Anjum · Accepted Answer · 2017-06-03 04:16:21Z

1

By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server. To redefine the mysql delimiter, use the delimiter command.

You can read about this in more detail create procedure.

Add "delimiter //"before create statement and "//" after end statement in order to execute your procedure. You can use any other delimiter as well.

edited Jun 3, 2017 at 4:16

answered Jun 2, 2017 at 18:37

Fahad Anjum

1,2561 gold badge10 silver badges19 bronze badges

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

1 Comment

Fahad Anjum Over a year ago

Is it helpful to you ?

Nigel Ren · Accepted Answer · 2017-06-02 19:31:15Z

0

In phpMyAdmin, you can set the delimiter on the SQL page, near the bottom, there is a line on the same area of the page as the Go button. Change the separator to anything ($$ is a common one) and then add this to the end of your script.

answered Jun 2, 2017 at 19:31

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

Collectives™ on Stack Overflow

Sql Syntax Error, on CREATE PROCEDURE

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related