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 vote112 views1 answer
How to check common records in 2 table
SQL
0 vote138 views1 answer
Insert output identity
SQL
5 votes108 views1 answer
Add column table sql default value
SQL
0 vote98 views1 answer
Mysql locate
SQL
0 vote98 views1 answer
Postgresql newline character
SQL
0 vote101 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote102 views1 answer
Case when with count and combining similar values in sql
SQL
-1 vote59 views2 answers
On delete set default sql server
SQL
16 votes102 views6 answers
Mysql find and replace
SQL
0 vote122 views1 answer
Mysql subtract month from timestamp
SQL