mysql 变量的使用

1.定义

SELECT '2017-10-01' INTO @beginDate;

SELECT '2017-11-01' INTO @endDate;

SELECT * FROM student WHERE birthday < @endDate AND birthday > @beginDate;

2.从表里面找出结果然后存储起来

SELECT name into @stuName FROM student WHERE id = 1000;

select @stuName;

3.变量

SELECT '2017-10-01' INTO beginDate;

SELECT '2017-11-01' INTO endDate;

SELECT * FROM student WHERE birthday < endDate AND birthday > beginDate;