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

2 votes204 views2 answers
Postgres change owner of schema
SQL
1 vote182 views1 answer
Backup mysql data only
SQL
1 vote176 views1 answer
Find difference in dates sql
SQL
0 vote183 views1 answer
Mariadb number format
SQL
50 votes192 views4 answers
Sql alter type of column
SQL
1 vote180 views1 answer
Python clean sql string
SQL
5 votes175 views1 answer
Oracle list packages
SQL
0 vote183 views1 answer
Mysql update from n to 100
SQL
9 votes196 views3 answers
Mysql show table column full description
SQL
20 votes190 views5 answers
Sql show tables
SQL