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

1 vote150 views1 answer
How to select multiple columns from different tables in mysql
SQL
2 votes157 views3 answers
How to get second highest salary in each department in sql
SQL
11 votes139 views4 answers
MYSQL LOGIN
SQL
0 vote148 views1 answer
Mysql date only no time
SQL
5 votes152 views2 answers
To date oracle
SQL
2 votes130 views1 answer
Postgresql left join distinct on
SQL
2 votes105 views1 answer
Sql select min value from multiple columns
SQL
1 vote139 views3 answers
Union in sql
SQL
0 vote146 views1 answer
Sqlite higher or equal
SQL
1 vote139 views1 answer
Hexadec to sql REDSHIFT
SQL