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:

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

1 solution

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
 
Share this answer
 
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.

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