Why comma is expected for auto_increment?
query = "CREATE TABLE "+TABLE+" ("+COLUMN1+" INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, "+COLUMN2+" VARCHAR(255), " + COLUMN3+" VARCHAR(255), "+COLUMN4+" TEXT, "+ COLUMN5+" VARCHAR(255), "+COLUMN6+" VARCHAR(255), "+COLUMN7+" TEXT)";
')',, ON or comma expected, got 'AUTO_INCREMENT'
I am very new to SQL. Earlier I was using Xampp.
Why comma expected for AUTO_INCREMENT? If I write the command something just like this :
"+COLUMN1+" INTEGER PRIMARY KEY NOT NULL ,AUTO_INCREMENT,
then I don't get the error/warning. But I think if I use comma then SQL may think AUTO_INCREMENT isn't for COLUMN1's. Cause it might be separated by comma.
I was trying to follow this answer:
"CUST_ID" INT not null primary key GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
But I got same error on GENERATED at first then AS. My attempt is available in the answer.
I have tried IDENTITY also.
Personid int IDENTITY(1,1) PRIMARY KEY,
same error for IDENTITY