Create Store Procedure in MySQL

Question

0.00/5 (No votes)

See more:

My Code:

SQL

CREATE PROCEDURE sp_insertuser(IN units varchar(50)
, IN serials VARCHAR(50)

, IN actives bit(1)
)
BEGIN

INSERT INTO tbldmng (
unit
, serial
, active
)

    VALUES (units
    , serials
    , actives
   );

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 17

Please tell me where is the problem actually. I don't know.
Thank you.

Posted 21-Mar-14 20:33pm

UL UL ALBAB

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

King Fisher · Answer 1 · 2014-03-21T20:38:00

Solution 1

SQL

CREATE PROCEDURE sp_insertuser(IN units varchar(50),IN serials VARCHAR(50), INactives bit(1))
BEGIN

INSERT INTO tbldmng (unit, serial, active) VALUES (units , serials , actives );
END //you missed this

Posted 21-Mar-14 20:38pm

King Fisher

Updated 21-Mar-14 20:39pm

v3

Comments

UL UL ALBAB 22-Mar-14 2:55am

No, this is not working.

King Fisher 22-Mar-14 3:16am

same error?

UL UL ALBAB 22-Mar-14 3:27am

yes. Is there another idea to create a store procedure in MYSQL Database ?

King Fisher 22-Mar-14 3:40am

http://stackoverflow.com/questions/2875238/passing-limit-as-parameters-to-mysql-sproc

UL UL ALBAB 22-Mar-14 8:05am

This also not helping me.

King Fisher 22-Mar-14 8:10am

what do you getting update your status..

Create Store Procedure in MySQL

1 solution

Solution 1

Add your solution here

Preview 0

Create Store Procedure in MySQL

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us