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

1 vote312 views1 answer
Create temporal table in sql
SQL
0 vote336 views1 answer
Last date for each user sql
SQL
15 votes336 views2 answers
Select where duplicate mysql
SQL
13 votes329 views4 answers
Command line mysql import
SQL
0 vote371 views3 answers
Mysql CAST(amount as float)
SQL
2 votes342 views1 answer
Q operator in sql
SQL
0 vote314 views1 answer
Mysql procedure between two tables
SQL
0 vote313 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote324 views1 answer
Docker open terminal mysql server
SQL
0 vote307 views1 answer
Deny select insert update delete sql
SQL