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 vote213 views1 answer
Oracle exchange subpartition
SQL
0 vote248 views2 answers
Start mysql server using docker
SQL
0 vote203 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote245 views1 answer
Oracle see column type
SQL
0 vote222 views1 answer
Exit psql
SQL
0 vote230 views3 answers
Sql parenthetical expression examples
SQL
0 vote224 views1 answer
Top frequency in sql server
SQL
3 votes201 views1 answer
Mysql UPDate with enner join
SQL
5 votes225 views2 answers
Postgres update with if condition query
SQL
0 vote232 views1 answer
Uncheck constraints and delete from table
SQL