locked
store procedure in mysql RRS feed

  • Question

  • User639567535 posted

    i try to create procedure in mysql but it shows me error

    Delimiter //
    CREATE PROCEDURE sp_login()
    BEGIN
    Select * from login where UName=@Uname and UPasword ;
    END //

    error

    There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem.
    
    ERROR: Unknown Punctuation String @ 93
    STR: //
    SQL: CREATE PROCEDURE sp_login()
    BEGIN
    Select * from login where UName=@Uname and UPasword ;
    END //
    
    
    SQL query: Documentation
    
    CREATE PROCEDURE sp_login() BEGIN Select * from login where UName=@Uname and UPasword ; END //
    
    MySQL said: Documentation
    #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 4 

    help?

    Tuesday, September 16, 2014 4:43 AM

Answers

All replies