Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Syntax error due to reserved names in Mysql

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 207
    Comment on it

    Hello Reader's!, On using Mysql with the some special resereved keywords the error :-

    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 <Keyword>
    

    It occurs because of the common calling of the mysql keywords and your name fields, This is and ambiguous situation stuck. So to avoid this situation coder should never use the reserved keywords but if you already had use then use the code format as written below:-

    INSERT INTO employee(name, age, `group`)
    

    Here the word group is a reserved keyword of Mysql so it's written in quotes

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: