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

6 votes137 views3 answers
How to delete table sqlite
SQL
-1 vote158 views1 answer
How to Activate the database
SQL
1 vote149 views5 answers
What is in operator in sql
SQL
5 votes146 views2 answers
Mysql import gzip db
SQL
5 votes138 views1 answer
Ignore duplicate rows in sqlite
SQL
3 votes153 views2 answers
Postgresql select all column names
SQL
0 vote93 views1 answer
Sql truncate table referencing itself
SQL
0 vote132 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote141 views1 answer
Closure in sql
SQL
0 vote147 views1 answer
Sparql list all graphs
SQL