MYSQL AS关键字错误

Question

我正在尝试在下面的 MYSQL 查询中使用 AS:

select ddb.customer_id, ddb.eta,ddb.vessel from tb_po
where transport_mode='SEA'  
and date(mv_eta_pod) between '2010-01-01' and  '2020-12-31' AS ddb;

但是，它告诉我 AS 关键字有错误。我的操作有问题吗？

Answer 1

使用 AS 为您使用的表定义别名，即 tb_po。

select ddb.customer_id, ddb.eta,ddb.vessel from tb_po AS ddb
where transport_mode='SEA'  
and date(mv_eta_pod) between '2010-01-01' and  '2020-12-31';