SET @motor_vehicle = ('vehicle','traffic');
select count(*) from '表' WHERE ‘字段’ in @motor_vehicle
这样子写报错了,如何定义一个列表结构的常量呢?
SET @motor_vehicle = ('vehicle','traffic');
select count(*) from '表' WHERE ‘字段’ in @motor_vehicle
这样子写报错了,如何定义一个列表结构的常量呢?
|
fuxkcsdnNov 13, 2019 via iPhone
1
用字符串拼接( concat )
|
|
gigantic222Nov 13, 2019
2
|