Run SQL on Android with SQLite in Termux 📱⚡ | Create DB & Query from Terminal #linux #android #sql

📲 Yes, you can run full SQL queries right from your Android device — no laptop or external tools needed!
In this YouTube Short, you’ll learn how to set up SQLite3 in Termux, create a local database, and start querying data — all from your terminal.

This tutorial covers:
⚙️ How to install SQLite3 inside Termux
🗃️ Creating a new database file (test.db)
🧱 Creating a simple users table with name & email
✍️ Inserting sample data (Alice & Bob)
🔎 Running SELECT queries to view your data
✅ Exiting and verifying the database file

🛠️ Key commands used:

pkg update && pkg upgrade
pkg install sqlite
sqlite3 test.db

📌 SQL commands:

CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, email TEXT);
INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com'), ('Bob', 'bob@test.org');
SELECT * FROM users;

By the end of this short, you’ll be running real SQL databases right from your Android phone using just Termux. Perfect for mobile devs, students, or anyone learning SQL.

💡 Use Cases:
- Practice SQL anywhere on Android
- Develop SQL-based apps in Termux
- Test database concepts offline

🔗 Related Tutorials:
- Essential Linux Commands - https://www.youtube.com/watch?v=VvQhT0e_58Q
- Nano Text Editor - https://www.youtube.com/watch?v=OcaIgOLOxl0

#Termux #SQLite #SQLonAndroid #MobileDev #TermuxTutorial #SQLiteAndroid #Shorts #AndroidDev #LinuxOnAndroid #SQLQueries #SQLite3

Видео Run SQL on Android with SQLite in Termux 📱⚡ | Create DB & Query from Terminal #linux #android #sql канала Halogenius Ideas