Skip to content

Instantly share code, notes, and snippets.

@lushl9301

lushl9301/sqlite3 result.db

Created June 8, 2015 02:37
Show Gist options
  • Save lushl9301/9346c92321b913373aff to your computer and use it in GitHub Desktop.
Save lushl9301/9346c92321b913373aff to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlite3 result.db
lu@dabian  ~/data  l
total 4.5M
drwxr-xr-x 2 lu lu 4.0K Jun 8 10:32 .
drwxr-xr-x 55 lu lu 4.0K Jun 8 10:33 ..
-rw-r--r-- 1 lu lu 5.0K Jun 3 15:51 project.db
-rw-r--r-- 1 lu lu 1.3M Jun 3 15:51 result.db
-rw-r--r-- 1 lu lu 1.3M Jun 8 10:05 result.db.b
-rw-r--r-- 1 lu lu 1.8K Jun 3 16:06 scheduler.1d
-rw-r--r-- 1 lu lu 2.9K Jun 3 16:06 scheduler.1h
-rw-r--r-- 1 lu lu 208 Jun 3 16:06 scheduler.all
-rw-r--r-- 1 lu lu 2.0M Jun 3 15:51 task.db
lu@dabian  ~/data  sqlite3 result.db
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
resultdb_pubmed
sqlite> .output raw_data.json
sqlite> select result from resultdb_pubmed;
sqlite> .quit
lu@dabian  ~/data 
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment