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

2 votes175 views1 answer
Mysql change data type of column
SQL
0 vote181 views1 answer
Duplix print in Smartforms
SQL
0 vote177 views1 answer
Querry mysql by 2 columns
SQL
4 votes173 views3 answers
Employee name starting with in sql
SQL
3 votes224 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
2 votes169 views1 answer
Metasploit start postgresql
SQL
1 vote180 views5 answers
Postgresql difference between two dates in days
SQL
1 vote161 views1 answer
Alter table column size oracle
SQL
0 vote180 views1 answer
Postgresql array to rows
SQL
0 vote170 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL