Search
 
SCRIPT & CODE EXAMPLE
 

SQL

ruby sqlite

require 'sqlite3'​# Browser history db = SQLite3::Database.new "places.sqlite"​# List all tables db.execute  "SELECT * FROM sqlite_master where type='table'"​# List all visited URLs (History)db.execute  "SELECT url FROM moz_places"# List all bookmarksdb.execute  "SELECT title FROM moz_bookmarks"​# List all Cookiesdb = SQLite3::Database.new "cookies.sqlite"db.execute  "SELECT baseDomain, name, host, path, value FROM moz_cookies"​# List all form historydb = SQLite3::Database.new "formhistory.sqlite"db.execute  "SELECT fieldname, value FROM moz_formhistory"
Comment

PREVIOUS NEXT
Code Example
Sql :: delete join sql server 
Sql :: SQL MIN() Function 
Sql :: .sql File Run in PSQL 
Sql :: postgres where 
Sql :: sql count * vs count 1 
Sql :: sql decimal with 2 places 
Sql :: sql like operator 
Sql :: primary key 
Sql :: cardinality example sql 
Sql :: nested query 
Sql :: mysql procedure 
Sql :: postgresql functions 
Sql :: in sqlalchemy 
Sql :: sql offfset 
Sql :: use table postgres 
Sql :: add column to all tables after first column mysql 
Sql :: sql server manager close connection 
Sql :: mysql group by derived column 
Sql :: PDOException: SQLSTATE[HY093]: Invalid parameter numb 
Sql :: where in clause tsql 
Sql :: Un mask mysql 
Sql :: basic structure of sql expression having clause 
Sql :: AND Operator (AND) 
Sql :: mysql Puede ser solamente un campo automatico y este debe ser definido como una clave 
Sql :: Get top 1 row of each group 
Sql :: prodection ready postgres database step by step 
Sql :: SQL Combining Multiple Operators 
Sql :: how to import sqlite driver class in java using maven 
Sql :: trigger stock phpmyadmin output message 
Sql :: alling a function from PL/SQL in a select statement in ORACLE 
ADD CONTENT
Topic
Content
Source link
Name
9+1 =