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

3 votes320 views1 answer
Show index table
SQL
1 vote337 views2 answers
Copy database mysql
SQL
0 vote395 views1 answer
Pl sql join 3 tables
SQL
-1 vote336 views1 answer
Mysql change database charset and collation
SQL
1 vote316 views1 answer
Mysql find tables with column name
SQL
17 votes356 views4 answers
Mysql remove ubuntu
SQL
6 votes374 views2 answers
Mysql convert timestamp to date
SQL
4 votes325 views1 answer
Select nls_date_format
SQL
0 vote346 views1 answer
Get who is hired in february in sql
SQL
1 vote324 views1 answer
Get url of cpanel database hostname
SQL