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 vote240 views1 answer
Delete record by id sql
SQL
0 vote230 views1 answer
No suitable driver found for sqlite
SQL
0 vote220 views1 answer
Dump only schema
SQL
-1 vote239 views5 answers
Online sql to linq generator
SQL
0 vote249 views1 answer
Can we rollback in sql
SQL
0 vote240 views1 answer
Ksql quickstart docker
SQL
1 vote239 views1 answer
Mysql month name extract
SQL
3 votes244 views1 answer
RENAME table pl sql
SQL
2 votes232 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote187 views1 answer
Check if has alpha characters sql
SQL