一开始SQL中有中文,报错backquoted identifiers are not supported,use double quotes to quote identifiers,然后我把中文加双引号,报错current transaction is aborted, commands ignored until end of transaction bl
select Shipper_Contact,
Shipper_Company,
case when substr(yx_titie,1,2)='湖北' then '湖北' else '其他' end,
Shipper_Email,
Shipper_Street,
Shipper_District
from myr_address
where statis_date>='20220801'
and statis_date<'20220901'
一开始case when里的中文用的单引号,后面改成双引号还是报错