Click here to Skip to main content
15,940,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
My Code:

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

, IN actives bit(1)

INSERT INTO tbldmng (
, 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.

1 solution

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

INSERT INTO tbldmng (unit, serial, active) VALUES (units , serials , actives );
END //you missed this
Share this answer
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
UL UL ALBAB 22-Mar-14 8:05am    
This also not helping me.

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900