让 mysql select 语句返回完全限定的列名，如 table.field [英] have mysql select statement return fully qualified column names like table.field

问题描述

有没有办法让 mysql select 语句返回完全限定的列名，如table.field"，而不对每个字段都使用 AS?

is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field?

像这样:

SELECT * 
FROM  table1  
LEFT JOIN table2 on table1.f_ID = table2.ID  

结果是:"table1.ID", "table1.name", "table2.ID", "table2.name", ...

and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

推荐答案

并非如此.您可以编写一些动态 SQL 来完成此操作，但这并不简单.如果您真的想要动态 SQL，请告诉我，我可以尝试制作一些东西.

Not really. You could write some dynamic SQL to accomplish this, but it wouldn't be simple. If you really want the dynamic SQL, let me know and I could try to whip something up.

这篇关于让 mysql select 语句返回完全限定的列名，如 table.field的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！