我想知道为什么这个mysql查询在phpmyadmin版本:4.7.1上有错误。请参阅随附的屏幕截图。我读到了phpmyadmin版本的问题,然后我将phpmyadmin升级到最新版本,但是在mysql中仍然会遇到这个错误。当我检查一个有效的sql时,它会显示无法识别的关键字和无法识别的令牌。
select
case
when venue like '% aklan %' then 'usa'
when venue like '% italy %' then 'italy'
when venue like '% china %' then 'china'
when venue like '% india %' then 'india'
end as cvenue,
count(*) as population
from
(
select concat(' ', venue, ' ') as venue
from tbl_trainings
) T
group by cvenue
最佳答案
试着把你的案例陈述放在括号里。然后执行查询:
select
(case
when venue like '% aklan %' then 'usa'
when venue like '% italy %' then 'italy'
when venue like '% china %' then 'china'
when venue like '% india %' then 'india'
end) as cvenue,
count(*) as population
from
(
select concat(' ', venue, ' ') as venue
from tbl_trainings
) T
group by cvenue
关于php - mysql大小写,然后无法识别的关键字和无法识别的 token ,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/44816345/