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 vote192 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote179 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
13 votes198 views3 answers
List all the tables in sql
SQL
0 vote176 views1 answer
Pl/ sql change currency
SQL
2 votes189 views3 answers
Sql interview query questions
SQL
2 votes190 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote169 views1 answer
Azure sql server check foreign key
SQL
0 vote180 views1 answer
Get the next column of a table in mysql
SQL
0 vote164 views1 answer
Truncate table sql server foreign key
SQL
1 vote192 views3 answers
Connection string mysql
SQL