上使用。
SELECT
DISPLAY_ID,
PICKER_NAME,
CREDIT,
HOURLY_RATE,
DAILY_RATE,
WEIGHT,
CASE
WHEN (DeviceGroups IS NOT NULL AND WorkerGroups IS NOT NULL) THEN CONCAT(DeviceGroups,',',WorkerGroups);
WHEN (DeviceGroups IS NULL AND WorkerGroups IS NOT NULL) THEN WorkerGroups;
WHEN (DeviceGroups IS NOT NULL AND WorkerGroups IS NULL) THEN DeviceGroups;
WHEN (DeviceGroups IS NULL AND WorkerGroups NOT NULL) THEN NULL;
END as GROUPS
FROM....
我尝试在语法上使用AS Alians时使用案例,我会得到此错误:
SQL查询:文档
选择display_id,picker_name,信用,hourly_rate,daily_rate,stright,strige,案件当(
设备组不是null工人组不是零)然后concat(devicegroups',',workerGroups);
mysql说:文档
1064-您的SQL语法有错误;检查与您的MySQL Server版本相对应的手册,以获取正确的语法,以便在第9行
删除分号:
SELECT
DISPLAY_ID,
PICKER_NAME,
CREDIT,
HOURLY_RATE,
DAILY_RATE,
WEIGHT,
CASE
WHEN (DeviceGroups IS NOT NULL AND WorkerGroups IS NOT NULL) THEN CONCAT(DeviceGroups,',',WorkerGroups)
WHEN (DeviceGroups IS NULL AND WorkerGroups IS NOT NULL) THEN WorkerGroups
WHEN (DeviceGroups IS NOT NULL AND WorkerGroups IS NULL) THEN DeviceGroups
WHEN (DeviceGroups IS NULL AND WorkerGroups IS NULL) THEN NULL
END as GROUPS
FROM....
在标准SQL中,使用半隆(;)来结束查询。