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: tutorialspoint.com

Similar codes

0 vote222 views2 answers
Drop tables from local table database postgres
SQL
0 vote182 views1 answer
How to move a columns location in mysql
SQL
0 vote196 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote178 views1 answer
Install mysql for fedora 34
SQL
2 votes192 views1 answer
Query any digits record
SQL
1 vote227 views1 answer
Postgresql if 0 then 1
SQL
0 vote196 views1 answer
Sum sqlserver
SQL
0 vote186 views1 answer
Select only one row sql
SQL
0 vote227 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote199 views1 answer
How to find table lock and row lock in mysql
SQL