/SQL/Stored procedure to delete data from table in mysql

Stored procedure to delete data from table in mysql

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 vote184 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote181 views1 answer
Insert into select with group by
SQL
0 vote175 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote177 views1 answer
Sqlplus change user
SQL
0 vote178 views1 answer
MySQL - Enabling the Event Scheduler
SQL
6 votes192 views3 answers
Date_trunc postgres
SQL
0 vote190 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
3 votes270 views1 answer
Oracle show trigger code
SQL
17 votes181 views3 answers
How to change a collumn name in sql
SQL
9 votes194 views6 answers
Oracle substring
SQL