SQL syntax error,

Question

This small query is driving me crazy. I keep getting errors no matter what I try

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

This is the code

CREATE PROCEDURE deposit (
    IN custAccount INT(11),
    IN amount INT(11)
)
IF amount < 0 THEN
    SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Invalid amount';
END IF;

The procedure is incomplete, dont judge it yet :D Thanks

Possible duplicate of: stackoverflow.com/questions/5703441/… or stackoverflow.com/questions/18005685/… or stackoverflow.com/questions/19801489/… . Don't forget to google before asking new questions. (: — Neeku
– Neeku, Commented Feb 5, 2014 at 19:32

Elliptical view · Accepted Answer · 2014-02-05 20:10:30Z

0

"The example uses the mysql client delimiter command to change the statement delimiter from ; to // while the procedure is being defined. This enables the ; delimiter used in the procedure body to be passed through to the server rather than being interpreted by mysql itself."

answered Feb 5, 2014 at 20:10

Elliptical view

3,9622 gold badges35 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

SQL syntax error,

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related