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 vote495 views1 answer
Sql insert exemplo
SQL
0 vote334 views1 answer
Recover deleted data from mysql database
SQL
7 votes340 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
1 vote336 views1 answer
Postgres get timestamp
SQL
0 vote373 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote383 views2 answers
Port 5432 is already in use mac
SQL
1 vote338 views1 answer
Oracle explain plan
SQL
3 votes399 views2 answers
Update part of a string in mysql
SQL
0 vote336 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote353 views2 answers
What is the default password for sql server sa
SQL