Mini SQL is a simple C program that allows you to run basic SQL-like queries on a text-based database (students.txt).
It supports SELECT queries with optional WHERE clauses.
SELECT *to display all data.- Select specific fields like
SELECT name, age FROM students;. - Filter data using
WHERE, e.g.,SELECT name, grade FROM students WHERE age=20;. - Exit the program using
EXIT;.
- Compile the program:
gcc code.c -o mini-sql
- Run it:
./mini-sql
For Windows (Git Bash):
gcc code.c
./a.exe> SELECT * FROM students;
id name age grade
1 Rahim 20 A
2 Karim 21 B
*.exe
*.o
.vscode/
.vs/
*.zip
Developer: MD Razwanul Islam
Begum Rokeya University, Rangpur
16th Batch