Sunday 11 June 2017

sql - Syntax error in MySQL check manual

 CREATE TABLE info(id KEY AUTO_INCREMENT, email VARCHAR(20), name VARCHAR(20));

While using this code, in Ubuntu terminal, i am getting error like below



ERROR 1064 (42000): 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 'KEY AUTO_INCREMENT, email VARCHAR(20), name
VARCHAR(20))' at line 1



pls do help me for this problem. Thanks to replies in advance

No comments:

Post a Comment

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...