TA貢獻(xiàn)1802條經(jīng)驗(yàn) 獲得超10個(gè)贊
@):
NULL
SELECT @var_any_var_name
SETSELECT
SET @start = 1, @finish = 10;
SELECT @start := 1, @finish := 10;SELECT * FROM places WHERE place BETWEEN @start AND @finish;
SELECT
DECLARE
DELIMITER //CREATE PROCEDURE sp_test(var1 INT) BEGIN DECLARE start INT unsigned DEFAULT 1; DECLARE finish INT unsigned DEFAULT 10; SELECT var1, start, finish; SELECT * FROM places WHERE place BETWEEN start AND finish; END; //DELIMITER ;CALL sp_test(5);
DEFAULTNULL.
BEGIN ... END
@@):
GLOBAL, SESSIONBOTH.
SHOW VARIABLESSELECT @@var_name.
SHOW VARIABLES LIKE '%wait_timeout%';SELECT @@sort_buffer_size;
SET GLOBALSET SESSION:
-- Syntax to Set value to a Global variable:SET GLOBAL sort_buffer_size=1000000;SET @@global.sort_buffer_size=1000000; -- Syntax to Set value to a Session variable:SET sort_buffer_size=1000000;SET SESSION sort_buffer_size=1000000;SET @@sort_buffer_size =1000000;SET @@local.sort_buffer_size=10000;
TA貢獻(xiàn)1803條經(jīng)驗(yàn) 獲得超6個(gè)贊
集
SET @var_name = value
SET @var := value
選擇
SELECT col1, @var_name := col2 from tb_name WHERE "conditon";
SELECT col1, col2 INTO @var_name, col3 FROM .....
TA貢獻(xiàn)1856條經(jīng)驗(yàn) 獲得超11個(gè)贊
舉報(bào)