SQLite – Introduction; Features; CRUD operation on table

DATABASE 101

INTRO CREATE READ UPDATE DELETE PLAYGROUND

Your Digital Filing Cabinet

Imagine a database as a highly organized filing cabinet. Whether it's your contact list or a game leaderboard, apps use databases to store, manage, and retrieve information. To interact with this cabinet, you need to master CRUD.

C

Create

R

Read

U

Update

D

Delete

The Blueprint: students Table

Column	Type	Constraint
id	INTEGER	PK AutoIncrement
name	TEXT	NOT NULL
course	TEXT	-
marks	INTEGER	-

C

Create: Adding Data

Use INSERT INTO to add new rows.

INSERT INTO students (name, course, marks) VALUES ('Ravi', 'Android', 85);

R

Read: Retrieving Data

Use SELECT to fetch data.

SELECT * FROM students WHERE course = 'Android';

U

Update: Modifying Data

Use UPDATE to change existing data.

UPDATE students SET marks = 95 WHERE id = 1;

D

Delete: Removing Data

Use DELETE to remove rows permanently.

DELETE FROM students WHERE id = 2;

Kid's Corner

The CRUD Playground

Be the Database Master! Add yourself to the list and see how it works.

🎮 Controls

Student Name

Score (0-100)

// System Ready...

Live Database Table 0 Rows

ID	Name	Course	Marks

📂

Database is empty. Create a student!

Mastering CRUD Basics © 2024