How to Insert Data into a SQLite Database - SQLite Tutorial

Hey everyone! Today we are going to take a look at how to write an insert statement for a SQLite database to insert some data. Thanks for watching!

[EthanActs]

Thank you so much. This was really helpful and the best tutorial i could find. Not even my teacher could teach like this. Thank you.

[JosephGallagher]

Reading the docs I found a whole section about using auto-increment, it should be avoided. SQLite identifies a column with INTEGER PRIMARY KEY as the ROWID as long as there is not another column with that same type listed in that table.