Procedures sql insert mysql

mysql> DELIMITER // ;
mysql> Create PROCEDURE insert_studentinfo(IN p_id int, IN p_name varchar(20),IN p_Address Varchar(20), IN p_subject Varchar(20))
    -> BEGIN
    -> insert into student_info(id, name, address, subject) values (p_id, p_name,p_address, p_subject);
    -> END //
Query OK, 0 rows affected (0.09 sec)

Source: tutorialspoint.com

Similar codes

3 votes147 views1 answer
V$session not found in oracle
SQL
0 vote192 views1 answer
Can we rollback in sql
SQL
2 votes192 views1 answer
Delete all value query
SQL
25 votes213 views5 answers
Uninstall mysql ubuntu
SQL
0 vote238 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote193 views1 answer
Not equal to blank in mysql
SQL
1 vote249 views1 answer
Mysql current running queries
SQL
0 vote227 views1 answer
Compare strings lexicographically in sql
SQL
0 vote263 views1 answer
Sql get table last modified time
SQL
1 vote231 views1 answer
Difference between where and having clause
SQL