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 vote290 views1 answer
Excel export from sql using python
SQL
0 vote305 views1 answer
Mysql order by rand limit 1 really slow
SQL
32 votes292 views6 answers
How to change column name in sql
SQL
0 vote280 views1 answer
Sql count matching group by
SQL
0 vote303 views2 answers
Temp tables in sql server
SQL
0 vote275 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote285 views1 answer
Foreign key type uniqu mysql
SQL
0 vote274 views2 answers
Update query with between in mysql
SQL
0 vote278 views1 answer
Do you know sql
SQL
0 vote279 views1 answer
TSQL convert csv to table
SQL