![]() ![]() ) Code language: SQL (Structured Query Language) ( sql ) ![]() The rowid column store 64-bit signed integer that uniquely identifies a row in the table.įirst, create a new table named people that has two columns: first_name, and last_name: CREATE TABLE people ( Whenever you create a table without specifying the WITHOUT ROWID option, you get an implicit auto-increment column called rowid. Summary: in this tutorial, you will learn about SQLite AUTOINCREMENT column attribute and when to use it in your table. ![]()
0 Comments
Leave a Reply. |