DELETE QUERY



MySQL - Delete Query


MySQL DELETE statement is used to delete a single record or multiple records from a table in MySQL.


SYNTAX

DELETE FROM table_name
WHERE condition;




First lets take a table with student details and check how DELETE works:


StudentIdStudentclassStudentmarks
1fifth500
2sixth465
3seventh520
4eighth450
5ninth555

Example - With One condition


DELETE FROM studentinfo
WHERE Studentclass = 'eighth';


Result will be displayed as follows:

StudentIdStudentclassStudentmarks
1fifth500
2sixth465
3seventh520
5ninth555

DELETE * FROM studentmarks


--------Result-------

# Before deleting system asks for the confirmation to delete or not.Then entire table gets deleted


MySQL TRIGGERS

MySQL - Triggers

posted on 2019-11-29 21:44:07 - mysql Tutorials


Grant_ Revoke Privilege

MySQL - Grant_ Revoke Privilege

posted on 2019-11-26 23:15:04 - mysql Tutorials


MySQL Vs SQL

MySQL Vs SQL

posted on 2019-11-25 05:02:26 - mysql Tutorials


how to use range in golang

how to use range in golang

posted on 2022-05-03 08:28:11 - Go lang Tutorials


find variable type in golang

find variable type in golang

posted on 2022-05-03 05:24:55 - Go lang Tutorials


for loops in golang

for loops in golang

posted on 2022-05-03 04:27:40 - Go lang Tutorials