mysql存储过程UPDATE [英] mysql stored procedure UPDATE
本文介绍了mysql存储过程UPDATE的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好
i我尝试使用存储过程来更新所选行,但它不能正常工作
这是我的sp
hello
i am try to update selected row using Stored Procedure but its not work weel
this is my sp
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `spr_StdUpdate`(
IN STUDENT_ID INT
,IN STUDENT_NAME VARCHAR(40)
,IN STUDENT_ADDRESS VARCHAR(60)
,IN STUDENT_MOBILE VARCHAR(20)
,IN STUDENT_CLASS VARCHAR(20)
,IN STUDENT_EMAIL VARCHAR(60)
)
BEGIN
UPDATE students SET
name=STUDENT_NAME,
address=STUDENT_ADDRESS,
mobile=STUDENT_MOBILE,
class=STUDENT_CLASS,
email=STUDENT_EMAIL
WHERE
ID=STUDENT_ID;
END
I Call it from php like this
mysql_query("Call spr_StdUpdate('$name', '$address' ,'$mobile' ,'$class' ,'$email','$ID')")
or die(mysql_error());
但它不起作用
but its not work
推荐答案
CREATE DEFINER =`root` @`localhost` PROCEDURE `spr_StdUpdate`(
IN STUDENT_ID INT
, IN STUDENT_NAME VARCHAR ( 40 )
, IN STUDENT_ADDRESS VARCHAR ( 60 )
, IN STUDENT_MOBILE VARCHAR ( 20 )
, IN STUDENT_CLASS VARCHAR (< span class =code-digit> 20 )
, IN STUDENT_EMAIL VARCHAR ( 60 )
)
BEGIN
更新学生 SET
name = STUDENT_NAME,
address = STUDENT_ADDRESS ,
mobile = STUDENT_MOBILE,
class = STUDENT_CLASS,
email = STUDENT_EMAIL
WHERE
ID = STUDENT_ID;
END
我称之为来自 php 喜欢这个
mysql_query( 调用spr_StdUpdate('
CREATE DEFINER=`root`@`localhost` PROCEDURE `spr_StdUpdate`( IN STUDENT_ID INT ,IN STUDENT_NAME VARCHAR(40) ,IN STUDENT_ADDRESS VARCHAR(60) ,IN STUDENT_MOBILE VARCHAR(20) ,IN STUDENT_CLASS VARCHAR(20) ,IN STUDENT_EMAIL VARCHAR(60) ) BEGIN UPDATE students SET name=STUDENT_NAME, address=STUDENT_ADDRESS, mobile=STUDENT_MOBILE, class=STUDENT_CLASS, email=STUDENT_EMAIL WHERE ID=STUDENT_ID; END I Call it from php like this mysql_query("Call spr_StdUpdate('
name','
address','
address' ,'
这篇关于mysql存储过程UPDATE的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文