mysql 批量添加字段前缀_MySQL自动添加前缀到字段

Example table1:

id | field1 | field2

--------------------

table2:

id | id1 | field1 | field2

--------------------------

Is it possible to do this:

select t1.*, t2.* from table1 t1 inner join table2 t2 on t1.id = t2.id1

and receive this result:

t1_id | t1_fiedl1 | t1_field2 | t2_id | t2_id1 | t2_fiedl1 | t2_field2

----------------------------------------------------------------------

The goal is to make mysql auto add prefixes to resulting fields, to avoid long typings, such as

select t1.id as t1_id, t1.field1 as t1_field1

and so on

解决方案

The SQL engine will not rewrite your query to "auto-alias" fields for you — aliases must be explicit.

You have two options in client code, however.

First, you could obviously write an abstraction that pieces together the query and provides aliases while doing so.

Second, and easier, is using the information exposed in the underlying MYSQL_FIELD structures associated with each result set. These contain the field and table name (and other information) about each field, allowing you to stitch together t1_field1 programmatically and without knowing field names in advance. How this info is exposed depends on your particular client API.