Creating a table in SQLite

  • 90 views

In this tutorial video, I create a simple 2-column table in SQLite using the CREATE TABLE command (a data definition language command). The first column is reserved for the PRIMARY KEY, an INTEGER row counter, and it is auto-incremented. The second column is available for TEXT input.