mysql drop row code example
Example 1: mysql delete row
DELETE FROM products WHERE product_id=1;
Example 2: mysql delete entire row on condition
DELETE FROM table_name [WHERE Clause]
Example 3: mysql remove records
DELETE FROM table_name
WHERE condition;
Example 4: how to delete all the rows in a table without deleting the table in mysql
delete from tableName;
Example 5: stored procedure to delete data from table in mysql
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 ;