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

0 vote176 views1 answer
Myswql show full processlist
SQL
7 votes179 views1 answer
Oracle set sequence value to max(id)
SQL
7 votes203 views3 answers
SQL create a new table
SQL
22 votes220 views3 answers
Sql cheat sheet
SQL
0 vote230 views1 answer
Rabbitmq service not starting
SQL
5 votes198 views1 answer
Oracle asynchronous update
SQL
0 vote187 views1 answer
Oracle archivemode
SQL
3 votes205 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote203 views1 answer
Oracle string length
SQL
0 vote182 views1 answer
Postgres : ERROR: division by zero
SQL