Shulou(Shulou.com)06/01 Report--

CREATE PROCEDURE `addTicket` (in vipsql VARCHAR, in ordersql VARCHAR, in detailkey varchar, in detailsql VARCHAR) comment 'pending order (Drug Sale window)'

BEGIN

DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, NOT FOUND

Rollback

Start transaction

Set @ vid=@oid=''

Set @ outstr=''

Set @ errcode=200

Set @ errmsg=' succeeded'

If vipsql=0 then

Set @ tem=vipsql

Prepare tem from @ tem

Execute tem

Set @ rows=row_count ()

If @ rows

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.