如何创建存储过程以在MySQL表中插入值?
我们可以使用IN运算符创建一个存储过程,以在MySQL表中插入值。为了理解它,我们以一个名为“student_info”的表为例,该表具有以下数据:
mysql> Select * from student_info; +------+---------+-----------+------------+ | id | Name | Address | Subject | +------+---------+-----------+------------+ | 100 | Aarav | Delhi | Computers | | 101 | YashPal | Amritsar | History | | 105 | Gaurav | Jaipur | Literature | | 110 | Rahul | Chandigarh | History | +------+---------+------------+------------+ 4 rows in set (0.00 sec)
现在,通过如下创建名为“insert_studentinfo”的过程,我们可以将值插入“student_info”表中-
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 //现在,使用我们要在表中插入的值调用过程,如下所示:
mysql> CALL insert_studentinfo(125,'Raman','Bangalore','Computers')// mysql> DELIMITER ; // mysql> Select * from Student_info; +-----+---------+------------+------------+ | id | Name | Address | Subject | +-----+---------+------------+------------+ | 100 | Aarav | Delhi | Computers | | 101 | YashPal | Amritsar | History | | 105 | Gaurav | Jaipur | Literature | | 110 | Rahul | Chandigarh | History | | 125 | Raman | Bangalore | Computers | +------+---------+------------+-----------+ 5 rows in set (0.00 sec)
上面的结果集表明,这些值已插入表中。
热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下