#PYTHON SQLITE AUTOINCREMENT CODE#

Note the CREATE TABLE line with AUTOINCREMENT, although it's not necessary as sqlite3 will do AUTOINCREMENT on any INTEGER PRIMARY KEY.

#PYTHON SQLITE AUTOINCREMENT CODE#

With that out of the way, the problem with your code is that autoincrement is specified at table creation time, not insertion time.Ĭ.execute('CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)')Ĭ.execute('INSERT INTO users ('name') VALUES (?)', (NameCreate, )) In SQLite, a column with type INTEGER PRIMARY KEY is an alias for the ROWID (except in WITHOUT ROWID tables) which is always a 64-bit signed integer. The AUTOINCREMENT keyword imposes extra CPU, memory, disk space, and disk I/O overhead and should be avoided if not strictly needed. We start with two pieces of warning from sqlite doc: It's not enough to show your operations on the database. PasswordCreate = input('Please enter your desired Password: ')ĭOBCreate = input('Please enter your date of birth : ')įavouriteArtistCreate = input('Please enter your favourite Arist: ')įavouriteGenreCreate = input('Please enter your favourite Genre: ')Ĭ.execute('INSERT INTO Users VALUES (AUTOINCREMENT, '')'.format(NameCreate, DOBCreate, UserNameCreate, PasswordCreate, FavouriteArtistCreate, FavouriteGenreCreate)) UserNameCreate = input('Please enter your desired User Name: ') NameCreate = input('Please enter your First and Last name: ') When a new User inputs their data, how do I make it so it automatically sets 'UserID' to the next number, in this case 6.Įverything works if I manually put '6' in the first Value (in the following code), but how do I make that automatic? conn = nnect('xxxxxxx.db') Each user gets their own ID, and so far there are 5 users. I then take that input and put it in my Table, however, I am having an issue with the AutoIncrementing 'User ID'. In my TEST program, users input their fake information when asked for an input. I am currently having an issue with importing data to a sqlite3 table.

Python sqlite autoincrement