[FREE Example Code] Learn Basic SQLite Queries - Build SQLite DB

[Frank 177]

Thanks Nick. Very interesting!! I'm going to investigate this alternative too. But when using the paid plugin, question for you, I know how to do an insert into a table, but what's the most effective way to get back the result with a row number right after the entry, from your experience.

 

Frank

[Code Docta (Nick C.) 638]

This is proll;y the best

 

4 down vote accepted

The SQL statement SELECT max(id) FROM table_name should give you the maximum id. If you're auto-incrementing then this would be the same as the last inserted.

 

source http://stackoverflow.com/questions/13177324/cant-get-the-last-row-id-from-sqlite3-database

 

here is a couple resources for python

 

SQLite Python tutorial really gooood

▶ Python 2.7 Tutorial Pt 12 SQLite - YouTube

 

Hope that helps.

CD

[Frank 177]

Hey Nick, awesome. I've been looking into the Python method too. I'll be trying the max function for sure.

[steelersfan 38]

Any chance on an update for this? The needed plugins from Aymen (file management and string management) are no longer available, so I can't run this to learn.

[Code Docta (Nick C.) 638]

I intend to make a python one too so you wont need the sqlite plugin either.