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
- [Video] 28+ Methods to Make Money Online: The Ultimate Tier List from S-Tier through F-Tier
- [BASH, cURL] Yellow Pages Scraper: Fully Functional Script with Source Code
- [cURL, BASH] How to Crawl and Scrape DuckDuckGo Search Results
- The Basics to Web Scraping with cURL and XPath
- Extracting Emails from HTML with Google Sheets: Get Contact Information in Bulk for Guest Posts, (lmao) 404 Re...
- [Infographic] The Beginner's SQLite Cheat Sheet
- Analyzing the Web: Downloading the Majestic Million, Setting up SQLite, Crawling the Web, and Generating Repor...
- Downloading Bulk Images: ThisPersonDoesNotExist with Python and urllib2
- An introduction to scraping with Python and BeautifulSoup
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.
Post a New Comment
Do you like having a good time?
Register an Account
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.