問題找到了。。。。select 寫成了 selcet。。。。o(╯□╰)o

DELIMITER?$$
CREATE?PROCEDURE?`seckill`.`execute_seckill`
	(in?v_seckill_id?bigint,?in?v_phone?bigint,
	?in?v_kill_time?timestamp,?out?r_result?int)
	BEGIN
		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);
		selcet?row_count()?into?insert_count;
		IF?(insert_count?=?0)?THEN
			ROLLBACK;
			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;
			selcet?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;
$$

這是照著老師寫的存儲過程代碼