DECLARE @variable_name datatype;

-- 聲明一個(gè)整數(shù)變量，還可直接這樣定義 DECLARE @MyNumber INT=10;
DECLARE @MyNumber INT;
-- 為變量賦值
SET @MyNumber = 10;
-- 使用變量
SELECT @MyNumber AS 'My Number';

-- 聲明變量
DECLARE @FirstName VARCHAR(50);
DECLARE @LastName VARCHAR(50);
DECLARE @FullName VARCHAR(100);
-- 賦值
SET @FirstName = 'John';
SET @LastName = 'Doe';
-- 連接字符串
SET @FullName = @FirstName + ' ' + @LastName;
-- 使用變量
SELECT @FullName AS 'Full Name';

-- 聲明變量
DECLARE @Threshold INT;
DECLARE @Result VARCHAR(50);
-- 賦值
SET @Threshold = 50;
-- 條件判斷
IF @Threshold > 100
    SET @Result = 'Above 100';
ELSE
    SET @Result = '100 or Below';
-- 使用變量
SELECT @Result AS 'Result';

-- 聲明變量
DECLARE @Counter INT;
DECLARE @MaxCount INT;
-- 賦值
SET @Counter = 1;
SET @MaxCount = 5;
-- 循環(huán)
WHILE @Counter <= @MaxCount
BEGIN
    PRINT 'Counter is ' + CAST(@Counter AS VARCHAR(10));
    SET @Counter = @Counter + 1;
END

SET @variable_name = value;

-- 聲明并賦值變量
SET @MyNumber = 10;
-- 使用變量
SELECT @MyNumber AS 'My Number';

-- 聲明并賦值變量
SET @FirstName = 'John';
SET @LastName = 'Doe';
-- 連接字符串
SET @FullName = CONCAT(@FirstName, ' ', @LastName);
-- 使用變量
SELECT @FullName AS 'Full Name';

– 聲明并賦值變量
SET @Threshold = 50;
– 條件判斷
IF @Threshold > 100 THEN
SET @Result = ‘Above 100';
ELSE
SET @Result = ‘100 or Below';
END IF;
– 使用變量
SELECT @Result AS ‘Result';

DELIMITER $$
CREATE PROCEDURE LoopExample()
BEGIN
    DECLARE Counter INT DEFAULT 1;
    DECLARE MaxCount INT DEFAULT 5;
    -- 使用準(zhǔn)備好的語句進(jìn)行循環(huán)
    PREPARE stmt FROM 'SELECT ? AS Counter';
    WHILE Counter <= MaxCount DO
        EXECUTE stmt USING @Counter;
        SET Counter = Counter + 1;
    END WHILE;
    DEALLOCATE PREPARE stmt;
END$$
DELIMITER ;
-- 調(diào)用存儲(chǔ)過程
CALL LoopExample();

-- 聲明并賦值變量
SET @Threshold = 50;
-- 條件判斷
IF @Threshold > 100 THEN
    SET @Result = 'Above 100';
ELSE
    SET @Result = '100 or Below';
END IF;
-- 使用變量
SELECT @Result AS 'Result';

-- 聲明并賦值變量
SET @Counter = 1;
SET @MaxCount = 5;
-- 使用準(zhǔn)備好的語句進(jìn)行循環(huán)
PREPARE stmt FROM 'SELECT ? AS Counter';
WHILE @Counter <= @MaxCount DO
    EXECUTE stmt USING @Counter;
    SET @Counter = @Counter + 1;
END WHILE;
DEALLOCATE PREPARE stmt;