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 vote395 views2 answers
Mysql dump database tables only
SQL
2 votes351 views1 answer
Columns Present in a table
SQL
1 vote360 views1 answer
Wordpress change url phpmyadmin
SQL
2 votes367 views4 answers
2nd highest salary in mysql
SQL
0 vote345 views1 answer
Ksql quickstart docker
SQL
0 vote345 views1 answer
Postgres copy command
SQL
0 vote384 views1 answer
Get only one row in mysql
SQL
7 votes370 views1 answer
Mysql iif
SQL
4 votes414 views2 answers
Postgresql float data type
SQL
0 vote352 views1 answer
Oracle string substitution
SQL