我也碰到這個(gè)錯(cuò)誤，請(qǐng)問解決了嗎？

先在mysql客戶端執(zhí)行下這段sql，創(chuàng)建存儲(chǔ)過程。

DROP?PROCEDURE?IF?EXISTS?execute_seckill;

--?秒殺執(zhí)行存儲(chǔ)過程
DELIMITER?$$?--?console?";"?轉(zhuǎn)換為?"$$"

--?定義存儲(chǔ)過程
--?參數(shù)：in?輸入?yún)?shù);?out?輸出參數(shù)
CREATE?PROCEDURE?`seckill`.`execute_seckill`(
??IN?v_seckill_id?BIGINT?,
??IN?v_phone?BIGINT?,
??IN?v_kill_time?TIMESTAMP?,
??OUT?r_result?INT
)
??BEGIN
????--?insert_count?臨時(shí)變量定義(需要在事物開始之前定義）
????DECLARE?insert_count?INT?DEFAULT?0?;
????START?TRANSACTION?;
????INSERT?IGNORE?INTO?success_killed(
????seckill_id?,
????user_phone?,
????create_time
????)?VALUES?(
??????v_seckill_id?,
??????v_phone?,
??????v_kill_time
????)?;
????--?row_count():返回上一條修改類型sql(delete,insert,upodate)的影響行數(shù)
????--?row_count:?0:未修改數(shù)據(jù);?>0:表示修改的行數(shù);?<0:sql錯(cuò)誤/未執(zhí)行修改sql
????SELECT?ROW_COUNT()?INTO?insert_count?;
????IF?(insert_count?=?0)?THEN
??????ROLLBACK?;
??????--?設(shè)置滿足業(yè)務(wù)邏輯需要的返回結(jié)果?r_result
??????SET?r_result?=?-?1?;
????ELSEIF?(insert_count?<?0)?THEN
??????ROLLBACK?;
??????SET?r_result?=?-?2?;
????ELSE
??????UPDATE?seckill
??????SET?number?=?number?-?1
??????WHERE
????????seckill_id?=?v_seckill_id
????????AND?end_time?>?v_kill_time
????????AND?start_time?<?v_kill_time
????????AND?number?>?0?;
??????--?再次使用?row_count()
??????SELECT?ROW_COUNT()?INTO?insert_count?;
??????IF?(insert_count?=?0)?THEN
????????ROLLBACK?;
????????SET?r_result?=?0?;
??????ELSEIF?(insert_count?<?0)?THEN
????????ROLLBACK?;
????????SET?r_result?=?-?2?;
??????ELSE
????????COMMIT?;
????????SET?r_result?=?1?;
??????END?IF?;
????END?IF?;
??END?;
$$
--?代表存儲(chǔ)過程定義結(jié)束