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 vote259 views1 answer
Postgresql update auto_increment value
SQL
0 vote288 views1 answer
How to add more columns to a table in mysql
SQL
0 vote295 views1 answer
Sql reverse order of results
SQL
0 vote272 views1 answer
Mysql trim characters
SQL
0 vote300 views1 answer
Oracle select partition
SQL
0 vote295 views1 answer
Every Derived yable must have its own alias
SQL
1 vote296 views1 answer
Mysql get domain from url
SQL
6 votes290 views6 answers
Count mysql
SQL
2 votes308 views2 answers
Postgres add column integer
SQL
1 vote286 views1 answer
Mysql dump specific tables
SQL