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

-1 vote159 views1 answer
Phinehas Psalm 106
SQL
0 vote149 views1 answer
Sql database connectivity
SQL
0 vote149 views1 answer
Change date format in oracle query
SQL
0 vote171 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
22 votes146 views3 answers
Join three tables sql
SQL
6 votes149 views2 answers
Oracle undotbs usage
SQL
1 vote172 views1 answer
Get current date in pyspark sql
SQL
3 votes156 views3 answers
Stop mysql ubuntu
SQL
0 vote143 views1 answer
Create boolean column in MySQL with false as default value?
SQL
1 vote154 views3 answers
Epoch to datetime
SQL