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

0 vote122 views2 answers
How to install mssql on mac
SQL
0 vote107 views1 answer
Do postgresql
SQL
4 votes142 views2 answers
Postgresql float data type
SQL
0 vote106 views2 answers
Mysql on update current_timestamp
SQL
1 vote114 views1 answer
Sql in array query
SQL
8 votes124 views4 answers
How to calculate the age from date of birth in python
SQL
39 votes174 views4 answers
Select duplicates in sql
SQL
2 votes108 views1 answer
Mariadb JSON_EXTRACT
SQL
4 votes107 views2 answers
Mysql how to change default charset
SQL
1 vote125 views1 answer
Ubuntu access database from terminal
SQL