Google spreadsheet memo
列を番号で指定するところがキモく、多用しないほうがいい
ある範囲を、こういう条件で検索して、リストを出す。条件は複数かけるSUM(FILTER(..))
でやったりする。
sqlite3
sqlite> .schema nodes
CREATE TABLE "nodes" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"type" varchar(255),
"path" varchar(768) NOT NULL,
"description" varchar(255),
"visible" boolean DEFAULT 't' NOT NULL,
Count: 1 Time=0.25s (0s) Lock=0.00s (0s) Rows=0.0 (0), yohoushi[yohoushi]@localhost
SELECT `nodes`.* FROM `nodes` WHERE `nodes`.`type` IN ('S') AND `nodes`.`path` = 'S' LIMIT N
Count: 1922 Time=0.23s (450s) Lock=0.00s (0s) Rows=0.0 (0), yohoushi[yohoushi]@localhost
SELECT `nodes`.* FROM `nodes` WHERE `nodes`.`type` IN ('S') AND `nodes`.`path` = 'S' ORDER BY `nodes`.`id` ASC LIMIT N
Count: 8017 Time=0.09s (749s) Lock=0.00s (0s) Rows=0.9 (7563), yohoushi[yohoushi]@localhost
SELECT id FROM `nodes` WHERE `nodes`.`type` IN ('S') AND `nodes`.`path` = 'S' ORDER BY `nodes`.`id` ASC LIMIT N
test |