Syntax error in MySQL Error #1064

Question

I'm trying to execute the following query:

DELIMITER $$
USE user_access
CREATE PROCEDURE check_user_login(IN username VARCHAR(50),IN `password` VARCHAR(50))
BEGIN
SELECT 1
FROM user_access
WHERE UserName='$username' AND `Password`='$password'
END$$
DELIMITER ;

But getting this 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 'CREATE PROCEDURE check_user_login(IN username VARCHAR(50),IN `password` VARCHAR(' at line 2

What's wrong with the query?

Kris · Accepted Answer · 2016-05-31 09:24:04Z

1

Looks to me like there's no separation between use user_access and create procedure, perhaps this will help you along:

USE user_access;
DELIMITER $$
CREATE PROCEDURE ...

also, your parameter syntax looks wrong to me, you don't want '$username' just username should do as it is the name of your parameter.

answered May 31, 2016 at 9:24

Kris

42.1k9 gold badges78 silver badges103 bronze badges

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

2 Comments

ohadinho Over a year ago

now i'm getting: #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 'END' at line 6

ohadinho Over a year ago

here is the new query: USE storedb; DELIMITER $$ CREATE PROCEDURE check_user_login(IN username VARCHAR(50),IN password VARCHAR(50)) BEGIN SELECT 1 FROM user_access WHERE UserName=username AND Password=password END$$ DELIMITER ;

Arulkumar · Accepted Answer · 2016-05-31 09:39:34Z

0

You missed the ; in two places.

DELIMITER $$
USE user_access; -- you missed the semicolon
CREATE PROCEDURE check_user_login(IN username VARCHAR(50), IN `password` VARCHAR(50))
BEGIN
    SELECT 1
    FROM `user_access`
    WHERE UserName = username AND `Password` = `password`; -- you missed the semicolon
END$$
DELIMITER ;

answered May 31, 2016 at 9:39

Arulkumar

13.3k14 gold badges51 silver badges76 bronze badges

Collectives™ on Stack Overflow

Syntax error in MySQL Error #1064

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related