Check out example codes for "stored procedure to delete data from table in mysql". It will help you in understanding the concepts better.
Code Example 1
mysql> DELIMITER // ; mysql> Create Procedure Delete_studentinfo ( IN p_id INT) -> BEGIN -> DELETE FROM student_info -> WHERE ID=p_id; -> END // Query OK, 0 rows affected (0.11 sec) mysql> DELIMITER ; //
Code Example 2
DELETE FROM table_name WHERE condition; In this statement: First, specify the table from which you delete data. Second, use a condition to specify which rows to delete in the WHERE clause. for example: DELETE FROM customers WHERE id = 1;
Code Example 3
DELETE FROM table_name [WHERE Clause]
Learn ReactJs, React Native from akashmittal.com