What a great infographic.
Copy-Pasteable Version of the SQLite Commands Cheat Sheet
General SQLite Commands and Information
Default Open - sqlite3
Open Database - sqlite3 name.db
Read in SQL File
sqlite> .read file.sql
SQL Statements in SQLite
SELECT * FROM table_name;
First Ten Rows
SELECT * FROM table_name LIMIT 10;
SELECT * FROM table_name WHERE price > 100;
Match String that Starts with "D"
SELECT * FROM table_name WHERE name LIKE 'De%';
SELECT * FROM table_name ORDER BY name ASC;
SELECT * FROM table_name ORDER BY name DESC;
INSERT INTO table_name (col1, col2) VALUES (20, "DOG");
UPDATE table_name SET col1 = TRUE WHERE is_true = TRUE
DELETE from table_name WHERE is_bad <> TRUE;
> Greater than
< Less Than
>= Greater than or equal
<= Less than or equal
<> Not equal
BETWEEN Specify range
LIKE Match part of string
IN Is in a set of values
CREATE TABLE table_name (
id INTEGER PRIMARY KEY AUTOINCREMENT,
Importing and Exporting in SQLite
Importing from CSV
sqlite> .mode csv
sqlite> .import file.csv table_name
Export to CSV
sqlite> .mode csv
sqlite> .output file.csv
sqlite> SELECT * FROM table;
sqlite> .output stdout
August Garcia is some guy who used to sell Viagra on the Internet. He made this website to LARP as a sysadmin while posting about garbage like user-agent spoofing, spintax, the only good keyboard, virtual assitants from Pakistan, links with the rel="nofollow" attribute, proxies, sin, the developer console, literally every link building method, and other junk.
Account created 7 months ago.
163 posts, 847 comments, and 250 RAMs.
13 hours ago:
Posted thread [Solved, Basically] Nautilus - Open Multiple Tabs from Command Line?
Post a New Comment
Do you like having a good time?
Read Quality Articles
Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.
Argue with People on the Internet
Use your account to explain why people are wrong on the Internet forum.
Vandalize the Wiki
Or don't. I'm not your dad.
Ask and/or Answer Questions
If someone asks a terrible question, post a LMGTFY link.
Make Some Money
Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.