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 vote309 views3 answers
MySQL shutdown unexpectedly
SQL
4 votes288 views2 answers
Sql server date now
SQL
10 votes310 views4 answers
Else if mysql
SQL
0 vote301 views1 answer
How to find table lock and row lock in mysql
SQL
10 votes281 views1 answer
Create table oracle
SQL
0 vote336 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
2 votes278 views1 answer
Drop table purge
SQL
0 vote313 views1 answer
Mysql record group by created date count
SQL
0 vote239 views1 answer
Java spring boot connect to sql server
SQL
0 vote291 views1 answer
Update and keep original value sql
SQL