11/18/2023 0 Comments Tableplus sqlite![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |