Code Yarns ‍👨‍💻
Tech BlogPersonal Blog

Try SQL queries with SQLite

📅 2012-Oct-02 ⬩ ✍️ Ashwin Nanjappa ⬩ 🏷️ sql, sqlite ⬩ 📚 Archive

Trying SQL queries in SQLite

If you need to try or test some SQL queries in a flash, then there is no better option than SQLite. Almost all mainstream database engines are huge pieces of software requiring installation and configuration before they can be used. SQLite is tiny and ready to use right out of the box.

Download the SQLite zip file for Windows and unzip it. Run the sqlite3.exe file and your database engine is already running! Type SQL queries at its prompt and terminate every query with a semicolon. Have fun playing around with SQL queries 😊

Tried with: SQLite 3.7.14

© 2022 Ashwin Nanjappa • All writing under CC BY-SA license • 🐘📧