– 系统变量
SELECT @@VERSION
SELECT VERSION()
SELECT CURRENT_TIME
– 用户变量
-- 方法一:
SET @avg = (SELECT AVG(lastcou) FROM product);
SELECT @avg;
-- 方法二:
SELECT @avg := (SELECT AVG(lastcou) FROM product);
– 自定义变量 DECLARE-定义局部变量 delimiter-修改结束符
delimiter //
CREATE FUNCTION f1()
RETURNS INT
BEGIN
DECLARE a,b,c int DEFAULT 0;
set a = 3,b = 5;
set c= a+b;
RETURN c;
END //
delimiter ;
SELECT f1();