Create delete procedure 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 vote199 views2 answers
Script all indexes in a database
SQL
0 vote208 views1 answer
Postgres list all stored procedures query
SQL
3 votes237 views1 answer
Mysql group_concat distinct
SQL
0 vote196 views1 answer
Mysql listing get a particu particular user firsdt
SQL
2 votes192 views1 answer
Oracle find unusable indexes
SQL
0 vote196 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote192 views1 answer
Select from another database
SQL
0 vote206 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote201 views1 answer
Drop procedure sql
SQL
0 vote226 views1 answer
How to fetch data from database in sql
SQL