MYSQL存储过程和调用

最新推荐文章于 2024-09-19 16:47:21 发布

weixin_30808575

最新推荐文章于 2024-09-19 16:47:21 发布

阅读量61

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/yohen/articles/1148043.html

版权

工作中用到的逻辑写成存储过程来用 CREATE PROCEDURE `pro_getLibCount`(IN qtype INTEGER(11),IN qdesc varchar(50),IN qversion varchar(50),IN qname varchar(50),IN qpath varchar(50),IN qxml varchar(50),OUT libcount INTEGER(11)) BEGIN select count(question_id) into libcount from t_question_library where question_version = qversion; begin if(libcount=0) then insert into t_question_library (question_type,question_desc,question_version,file_name,file_path,question_xml) values(qtype,qdesc,qversion,qname,qpath,qxml); set libcount=last_insert_id(); else select question_id into libcount from t_question_library where question_version = qversion; end if; end; END 调用 call pro_getLibCount('3','part1_Q1','0BFDBF7D911FA8C6B28B1E20491B46B9','0BFDBF7D911FA8C6B28B1E20491B46B0.LPK','http://10.10.66.206/questionlibrary/','1-1.xml',@library); insert into t_paperquestion_library (paper_question_id,question_id) values('1',@library);

转载于:https://www.cnblogs.com/yohen/articles/1148043.html