mysql事务

CREATE PROCEDURE selectjm()
BEGIN
	#创建变量cnt, 初始值为0
	DECLARE cnt INT DEFAULT 0;
	#将查到的num字段,赋值给cnt
	select num into cnt from goods;
IF cnt>0 THEN
	#num自减1
	UPDATE goods SET num = (num-1);
END IF;
END