mysql赋值给变量

-- 创建一个示例表
CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    salary DECIMAL(10, 2)
);

-- 插入一些示例数据
INSERT INTO employees (id, name, salary) VALUES
(1, 'Alice', 5000.00),
(2, 'Bob', 6000.00),
(3, 'Charlie', 7000.00);

-- 将最高薪资赋值给变量
SET @max_salary = (SELECT MAX(salary) FROM employees);

-- 查询薪资等于最高薪资的员工
SELECT * FROM employees WHERE salary = @max_salary;

SET @my_variable = 'some_value';

DELIMITER //

CREATE PROCEDURE my_procedure()
BEGIN
    DECLARE my_variable VARCHAR(100);
    SET my_variable = 'some_value';
    -- 使用变量
END //

DELIMITER ;

SET @my_variable = CAST('123' AS INT);