Horje
mysql delete row Code Example
mysql delete row 
DELETE FROM products WHERE product_id=1;
delete record mysql query 
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;
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 ; //
Source: www.tutorialspoint.com




Related
sql where contains Code Example sql where contains Code Example
install sqlite3 python Code Example install sqlite3 python Code Example
select count of distinct values sql Code Example select count of distinct values sql Code Example
mysql set root password Code Example mysql set root password Code Example
how to change the value of a table in sql Code Example how to change the value of a table in sql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 11



 

Horje