sqlite3 :memory: 'SELECT 1;'

Category: Databases & SQL

sqlite3 :memory: 'SELECT 1;'

Test queries in an in-memory database

:memory: opens a temporary database that exists only for the command and vanishes at exit — perfect for experiments that should not touch disk. Related: a named file database persists.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.