select ip_type 'IP類型', timestamp '數據填報時間' from ( select d.id, if(d.ip_type = 0, 'IP', 'IP段') ip_type , d.timestamp, (CASE d.visible WHEN 0 THEN '否' WHEN 1 THEN '是' ELSE '' END)visible from aaa_tab d where timestamp <= '2022-04-30 23:59:59') t1 order by id desc

提示 SQL 錯誤 [1525] [HY000]: Incorrect DATETIME value: '數據填報時間'

修改為：t1.timestamp ，給 timestamp 加引號
select ip_type 'IP類型', t1.timestamp '數據填報時間' from ( select d.id, if(d.ip_type = 0, 'IP', 'IP段') ip_type , d.timestamp, (CASE d.visible WHEN 0 THEN '否' WHEN 1 THEN '是' ELSE '' END)visible from aaaa_tab d where timestamp <= '2022-04-30 23:59:59') t1 order by id desc