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 vote130 views1 answer
Psql datetime grather than
SQL
6 votes135 views3 answers
Oracle all dates between two dates
SQL
10 votes134 views6 answers
Between sql
SQL
19 votes131 views4 answers
Rename database in sql
SQL
0 vote137 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
1 vote131 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote146 views1 answer
Alter column to not null with default value sql server
SQL
0 vote145 views1 answer
How get data from database if id not found then search another column
SQL
1 vote128 views1 answer
Mysql best tutorial for beginners
SQL
-1 vote125 views2 answers
How to display top 50 rows?
SQL