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 vote169 views1 answer
Sql view index
SQL
3 votes278 views1 answer
Oracle show trigger code
SQL
4 votes180 views1 answer
Change nls_date_format
SQL
0 vote189 views1 answer
Select * from mysql.proc
SQL
0 vote630 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote177 views1 answer
Sql server order by nulls last
SQL
13 votes184 views2 answers
Get tables in database sql
SQL
0 vote180 views2 answers
Alter table add multiple columns mysql
SQL
2 votes175 views1 answer
How to delete view in sql
SQL
0 vote198 views1 answer
EnvironmentError: mysql_config not found
SQL