MySQL DELETE: Remove Records from a Table with Conditions

student_id	name	gender	city	age	score	course_id	email	phone_number
1	Alice	Female	Delhi	20	85	101	NULL	1234567890
2	Bob	Male	Mumbai	22	75	NULL	bob@email.com	NULL
3	Charlie	Male	Delhi	21	95	102	NULL	NULL
4	David	Male	Bangalore	23	65	101	david@email.com	NULL
5	Eve	Female	Mumbai	20	80	103	NULL	NULL
6	Frank	Male	Delhi	22	90	103	NULL	NULL
7	Alice	Female	Mumbai	19	60	102	NULL	NULL

1. Delete a Specific Row

The following SQL statement deletes the student where id = 5 from the "students" table:

Example

DELETE FROM students

WHERE id = 5;

The "Students" table will now look like this:

student_id	name	gender	city	age	score	course_id	email	phone_number
1	Alice Johnson	Female	Delhi	20	85	101	NULL	1234567890
2	Bob	Male	Mumbai	22	75	NULL	bob@email.com	NULL
3	Charlie	Male	Delhi	21	95	102	NULL	NULL
4	David	Male	Bangalore	23	65	101	david@email.com	NULL
6	Frank	Male	Delhi	22	90	103	NULL	NULL
7	Alice	Female	Mumbai	19	60	102	NULL	NULL

2. Delete All Rows in a Table (⚠️ Be Careful!)

It is possible to removes all records from the students table but keeps the table structure.. This means that the table structure, attributes, and indexes will be intact:

The following SQL statement deletes all rows in the "Students" table, without deleting the table:

Example

DELETE FROM Students;

❮ Previous

Next ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.