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 vote265 views1 answer
Nested if in mysql
SQL
0 vote275 views1 answer
Get relation data in mysql using query to excel
SQL
3 votes270 views1 answer
Oracle rollback
SQL
14 votes352 views1 answer
How to export db from mysql
SQL
1 vote261 views1 answer
Create sample data postgresql
SQL
1 vote266 views6 answers
In sql
SQL
0 vote276 views1 answer
Mysql date minus 1 day
SQL
3 votes278 views1 answer
Dbms_scheduler drop_job
SQL
1 vote284 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote324 views1 answer
Why do we need data structure in sql
SQL