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 vote403 views1 answer
Create pl/sql stored procedure
SQL
0 vote141 views1 answer
How to check the port of mysql installation in mac
SQL
22 votes149 views3 answers
Remove all records from table mysql
SQL
0 vote136 views1 answer
Mysql read row
SQL
2 votes156 views1 answer
Sql server current date minus 5 years
SQL
0 vote133 views1 answer
Mysql export and import
SQL
0 vote147 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
16 votes157 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
3 votes130 views2 answers
To_char oracle
SQL
2 votes131 views1 answer
When matched in sql server
SQL