SQLite version 3.12.0 2017-05-14 18:55:02.054 UTC
# compiled by GNU C version 6.2.0 20170519 (SUSE Linux), 64-bit
# platform. Adapted for zlib 1.2.11 build on Mon Jun 9 10:06:32 2017
# Using GCC version 9.2.0 (GCC) 20190702 (Red Hat 9.2.0-5) (9.2.0-7) (built for x86_64-redhat-linux-gnu).
#
# SQLite version 3.19.3.1
# Google :
#
# Access to database is restricted.
# User "guest" is not permitted to connect.
# SQLite was built with an older version of the library. If the version
# reported by the 'configure' script is different from the version of SQLite
# compiled, some features might be disabled or unavailable. Rebuild the
# database with SQLite built with the same version of the library.
# Create the table definitions and add a few records to the test table.
CREATE TABLE "test_tbl" ("label" TEXT,"id" INTEGER PRIMARY KEY,"rating" REAL);
# A simple query to select from test_tbl.
SELECT label FROM test_tbl LIMIT 10;
# The "id" column is a primary key and is also indexed by a secondary index.
SELECT COUNT(*) FROM test_tbl;
# Create the table, with a primary key on two columns.
CREATE TABLE "test_pk_tbl" ("label" TEXT,"id" INTEGER,"rating" REAL);
# An index on three columns.
CREATE INDEX "test_pk_index" ON "test_pk_tbl" ("label","rating");
# Delete rows from test_pk_tbl.
Related links:
Comments