MySQL DELETE Examples

DELETE - Row

Delete a row of data. 

START TRANSACTION
GO

DELETE FROM courses
WHERE  course_designater = 'Excel101' 
GO

COMMIT 
GO

DELETE - Multiple rows of data

Delete multiple rows of data. Be careful!

START TRANSACTION
GO

DELETE FROM courses
WHERE  course_designater LIKE 'Linux%' 
GO

COMMIT 
GO
 Collapse All    Expand All
Custom Search

MySQL Information and Resources