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

4 votes221 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote222 views1 answer
Remove binlog mysql
SQL
3 votes229 views1 answer
Oracle rollback
SQL
0 vote213 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote376 views1 answer
Get first match in each group mysql query
SQL
1 vote252 views1 answer
Floor function in sql oracle
SQL
12 votes227 views2 answers
Delete entries in postgresql
SQL
0 vote221 views3 answers
Mysql delete if not in another table
SQL
1 vote238 views1 answer
Search for replace in mysql
SQL
1 vote353 views3 answers
Uninstall postgresql mac
SQL