mysql 字段名為 timestamp ,不讓轉義
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

浙公網安備 33010602011771號