Deleting Data from a Table To delete rows, you use the DELETE statement. If you add a WHERE clause, you can choose which row or rows to delete; otherwise all the data in the table are deleted.
mysql > DELETE FROM Course WHERE Course id = 1;
Query OK, 1 row affected
mysql > SELECT * from Course;
Output
Course id | Course name | Duration |
2 | ASP.NET | 6 |
3 | MySql | 8 |
2 rows in set