Error
SQL query: Documentation
CREATE PROCEDURE `usecash`( in userid1 INTEGER, in zoneid1 INTEGER, in sn1 INTEGER, in aid1 INTEGER, in point1 INTEGER, in cash1 INTEGER, in status1 INTEGER, out error INTEGER ) BEGIN DECLARE sn_old INTEGER; DECLARE aid_old INTEGER; DECLARE point_old INTEGER; DECLARE cash_old INTEGER; DECLARE status_old INTEGER; DECLARE createtime_old DATETIME; DECLARE time_old INTEGER; DECLARE need_restore INTEGER; DECLARE exists1 INTEGER; DECLARE rowcount INTEGER; START TRANSACTION; SET error = 0; SET need_restore = 0; SELECT SQL_CALC_FOUND_ROWS sn, aid, point, cash, status, creatime INTO sn_old, aid_old, point_old, cash_old, status_old, createtime_old FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn >= 0; SET rowcount = FOUND_ROWS(); IF rowcount = 1 THEN SET exists1 = 1; ELSE SET exists1 = 0; END IF; IF status1 = 0 THEN IF exists1 = 0 THEN SELECT aid, point INTO aid1, point1 FROM usecashnow WHERE [...]
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 95