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

6 votes305 views4 answers
Sqlite drop table
SQL
0 vote307 views4 answers
Mysql select bottom 10 rows
SQL
0 vote324 views1 answer
Set root password mysql xampp
SQL
1 vote301 views1 answer
How to select random rows from table
SQL
-2 votes312 views1 answer
Remove root password mysql
SQL
4 votes336 views2 answers
Oracle unlock account
SQL
0 vote359 views1 answer
How to inner join 4 tables in sql
SQL
1 vote342 views1 answer
Mamp mysql path mac
SQL
0 vote313 views1 answer
Sql get month and year from date
SQL
1 vote310 views1 answer
Last 6 months postgresql
SQL