Lines Matching refs:SELECT
69 CREATE TEMP TABLE dbstat AS SELECT * FROM temp.stat ORDER BY name, path;
87 set sql { SELECT name, tbl_name FROM sqlite_master WHERE rootpage>0 }
92 SELECT
116 SELECT pageno FROM temp.dbstat WHERE name = $name ORDER BY rowid
214 SELECT
260 SELECT count(*) FROM (
261 SELECT DISTINCT tblname FROM space_used WHERE $where AND is_index=0
265 SELECT (sum(leaf_pages+int_pages)-$nTab)/sum(int_pages) FROM space_used
366 set sql {SELECT sum(leaf_pages+int_pages+ovfl_pages) FROM space_used}
377 set ntable [db eval {SELECT count(*)+1 FROM sqlite_master WHERE type='table'}]
378 set nindex [db eval {SELECT count(*) FROM sqlite_master WHERE type='index'}]
379 set sql {SELECT count(*) FROM sqlite_master WHERE name LIKE 'sqlite_autoindex%'}
383 # set total_payload [mem eval "SELECT sum(payload) FROM space_used"]
384 set user_payload [mem one {SELECT int(sum(payload)) FROM space_used
414 mem eval {SELECT tblname, count(*) AS cnt,
429 foreach tbl [mem eval {SELECT name FROM space_used WHERE NOT is_index
433 set n [mem eval "SELECT count(*) FROM space_used WHERE tblname='$qn'"]
609 mem eval {SELECT * FROM space_used} x {
