Debasis Mohapatra

Debasis Mohapatra

  • 1.5k
  • 376
  • 10.7k

Could you please any one answer correct the query

Oct 23 2019 11:59 PM
Hi,
 
 
could you please any one guide me why i am getting the error
 
CREATE TABLE sites (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT
);
 
Incorrect syntax near 'AUTO_INCREMENT
 
i have changed to 
 
CREATE TABLE sites (
[id] INTEGER PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50)
);
 
 
WHY THE SAME ERROR IS COMMING. COULD ANY ONE RESOLVED THE ISSUE. 
 

Answers (6)