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;
|Course id||Course name||Duration|
2 rows in set