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 votes123 views1 answer
Sql timestamp to date
SQL
0 vote129 views1 answer
How to check which sp is running in sql server
SQL
0 vote139 views1 answer
Basic structure of sql expression having clause
SQL
1 vote164 views1 answer
How not to sort by average rating
SQL
0 vote171 views1 answer
Plpgsql create function
SQL
0 vote145 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
1 vote123 views1 answer
Index a database column sql
SQL
1 vote137 views1 answer
Postgres first_value in gropby
SQL
4 votes150 views3 answers
Drop Table Oracle
SQL
2 votes148 views1 answer
Mysql select default if null
SQL