Skip to content

Instantly share code, notes, and snippets.

@rohitdholakia

rohitdholakia/SQLite.txt

Created January 9, 2012 07:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rohitdholakia/1581793 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rohitdholakia/1581793 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Queries to set up Twitter data processing
Raw
SQLite.txt
crazyabtliv@linux-hknk:~> sqlite3 twitter.db
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
sqlite> create table tweets (
...> username string,
...> tweet string);
sqlite> .tables
tweets
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment