Third, query data from the people table using the following SELECT statement: SELECT rowid,
VALUES( 'John', 'Doe') Code language: SQL (Structured Query Language) ( sql ) Second, insert a row into the people table using the following INSERT statement: INSERT INTO people (first_name, last_name) ) 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 kommentar(er)
