Mysql 中设置变量day的几种写法:
set @day = "2019-08-01";
set @day := "2019-08-01";
select @day := "2019-08-01";
注意:如果使用 select
关键词进行变量赋值时,不可以使用 =
号,因为会默认把它当作比较运算符,而不是赋值,但是用关键词 set
进行变量赋值时是可以直接用 =
号的
MySQL中变量的使用:
set @day = "2019-08-01";
select
order_id
from
t
where time1 = @day
and time2 = @day
and time3 = @day
and time4 = @day
Hive中变量的使用:
set day = "2019-08-01";
select
order_id
from
t
where time1 = ${hiveconf:day}
and time2 = ${hiveconf:day}
and time3 = ${hiveconf:day}
and time4 = ${hiveconf:day}