-- 设置变量
SET @where_str = "1";
INSERT INTO `te_teacher` (`name`, `sex`, `age`, `height`, `weight`) VALUES ('李倩', 0, 26, 165, 49);
DELETE FROM `te_teacher` WHERE id = @where_str;
UPDATE `te_teacher` SET id = 1 WHERE id = @where_str;
SELECT * FROM `te_teacher` WHERE id > @where_str;
-- 连接字符串
SET @a = 'a';
SET @b = 'b';
SELECT CONCAT(@a, @b);