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 votes195 views1 answer
Docker run postgres locally
SQL
0 vote231 views1 answer
Consecutive numbers sql
SQL
0 vote200 views1 answer
Minecraft duping allowed servers
SQL
2 votes217 views2 answers
Mysql write into table
SQL
10 votes174 views2 answers
Sql where clause multiple values
SQL
0 vote215 views1 answer
Get current date data in mysql
SQL
-1 vote207 views2 answers
First letter capital in mysql query
SQL
0 vote201 views1 answer
What is the use of index in mysql table
SQL
0 vote203 views2 answers
Postgresql display subquery as json
SQL
0 vote203 views1 answer
Power bi dax add related shows column but not working
SQL