1DELETE FROM table_name WHERE condition;
2In this statement: First, specify the table from which you delete data.
3Second, use a condition to specify which rows to delete in the WHERE clause.
4
5for example:
6DELETE FROM customers WHERE id = 1;
1mysql> DELIMITER // ;
2mysql> Create Procedure Delete_studentinfo ( IN p_id INT)
3 -> BEGIN
4 -> DELETE FROM student_info
5 -> WHERE ID=p_id;
6 -> END //
7Query OK, 0 rows affected (0.11 sec)
8
9mysql> DELIMITER ; //