More than 1 year has passed since last update.

sqlite3 command memo

SQL
SQLite3

Last updated at 2023-01-16Posted at 2022-07-31

sqlite3 memo

よく使うコマンド for sqlite3.

1. BASIC

> sqlite3 DATABESE.db

CREATE TABLE table1(col1 STRING, col2 INTEGER) -- create table

SELECT * from table1; -- get contents

SELECT col1 FROM table1 WHERE col2 = 3; -- with conditions

PRAGMA table_info('table1'); -- table info.
.tables -- show all tables

DROP TABLE 'table1'; -- delete table

.exit -- stop sqlite3 command-line

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up