如何在MySQL中为字段或列添加别名？

考虑使用子查询，例如：

SELECt col1,      col1 + field3 AS col3 FROM   (       SELECt  field1 + field2 as col1       ,       field3       from    core       ) as SubQueryAlias