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 vote353 views1 answer
Ksql quickstart docker
SQL
0 vote331 views1 answer
Mysql percentage of total
SQL
1 vote370 views1 answer
Alphabetical order mysql
SQL
3 votes342 views3 answers
Mysqldump: couldn
SQL
0 vote419 views1 answer
Postgres - Login and connect as default user
SQL
0 vote353 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote367 views1 answer
Mysql c commands
SQL
0 vote345 views1 answer
Sql query to select records entered in last 24 hours
SQL
11 votes800 views4 answers
Reset identity column values in sql server
SQL
1 vote389 views4 answers
Psql check tables command
SQL