SQLite LAST_INSERT_ROWID() problem

[-ffs-AbodyRulez]

    local ID = dbExec(db, "SELECT LAST_INSERT_ROWID() FROM joinHistory") 

this returns false for me, even though the database isn't empty.

i'm trying to create an auto_increment column, but just found out that sqlite doesn't support auto_increment, it's only supported by MySQL.

any help?

[JR10]

SQLite supports auto-increment. A column declared "INTEGER PRIMARY KEY" will auto-increment.

You can use last_insert_rowid() without specifying a table.

SELECT LAST_INSERT_ROWID() 

[Jusonex]

Also, you can't use dbExec to get the ID. You'll have to use dbQuery + dbPoll as follows:

local result = dbPoll(dbQuery(db, "SELECT LAST_INSERT_ROWID() AS `ID`"), -1) 
outputChatBox(result.ID) 

("FROM joinHistory" isn't necessary according to the SQLite documentation btw)

[JR10]

I didn't even notice that he was using dbExec.

dbExec never returns results, it only executes the given query.