File: sqlite3.sqlite3-console

package info (click to toggle)
ruby-pygments.rb 0.6.3-2%2Bdeb9u1
  • links: PTS, VCS
  • area: main
  • in suites: stretch
  • size: 8,628 kB
  • sloc: python: 46,993; ansic: 8,115; lisp: 3,703; cobol: 2,961; pascal: 2,750; ruby: 2,700; sh: 2,362; java: 1,755; cpp: 1,549; haskell: 926; ml: 831; csh: 681; f90: 459; php: 260; cs: 258; perl: 177; makefile: 174; ada: 161; objc: 145; erlang: 104; awk: 94; asm: 68; jsp: 21
file content (27 lines) | stat: -rw-r--r-- 600 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> .schema
CREATE TABLE paste (paste_id integer, code text, parsed_code text, pub_date
varchar(24), language varchar(64), parent_id integer, url varchar(128));
CREATE TABLE vars (key varchar(24), value varchar(128));
sqlite> a '
   ...> '
   ...> ;
SQL error: near "a": syntax error
sqlite> %;
SQL error: near "%": syntax error
sqlite> select count(language), language from paste group by language order
   ...> by count(language) desc;
144|python
76|text
22|pycon
9|ruby
7|c
7|js
6|html+django
4|html
4|tex
2|html+php
1|cpp
1|scheme
sqlite>