首页 > 数据库技术 > 详细

存储过程中使用运行查出的SQL

时间:2014-09-30 17:59:59      阅读:200      评论:0      收藏:0      [点我收藏+]
BEGIN
 declare u_name varchar(100);
 declare s_name varchar(100);
  set u_name=‘update ‘;
 set s_name=concat(‘ set cur_status =‘,‘90‘);
 set @u_table=CONCAT(u_name,t_name,s_name);
 select @sql_info :=sql_info from sql_info where code=code_info;
 PREPARE pre_sql from @sql_info;
 PREPARE pre_u from @u_table;
 EXECUTE pre_sql;
 EXECUTE pre_u;
 deallocate prepare pre_sql;
 deallocate prepare pre_u;
 update sql_info set use_time=UNIX_TIMESTAMP(NOW()) where code=code_info;
 update calculate_data  Set  cur_status = ‘39‘ Where  item = item_code;
 
end

 

存储过程中使用运行查出的SQL

原文:http://www.cnblogs.com/img-zoom/p/4002288.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!