mysql连接所有字段_mysql：重命名连接的所有字段

我没有发现任何相关信息.

这是我的查询：

SELECT p.*, pa.*, a.*

FROM produit p

LEFT OUTER JOIN produit_attribut pa

ON p.id=pa.id_produit

LEFT OUTER JOIN attribut a

ON a.id=pa.id_attribut

ORDER BY p.id,a.id;

但问题是它返回列

with the same name:

+----+------------+-----+------------+-------------+------+-----+----+----+

| id | titre | desc| id_produit | id_attribut | id | desc| val| abb|

+----+------------+-----+------------+-------------+------+-----+----+----+

| 1 | Anchois | Sauc| 1 | 1 | 1 | Nomb| 2 | Nb |

| 2 | Fromage | Sauc| 2 | 1 | 1 | Nomb| 2 | Nb |

| 3 | Mozzarella | Sauc| 3 | 1 | 1 | Nomb| 2 | Nb |

| 4 | Jambon | Sauc| 4 | 1 | 1 | Nomb| 2 | Nb |

| 5 | Roquefort | Sauc| 5 | 1 | 1 | Nomb| 2 | Nb |

| 6 | Royale | Sauc| 6 | 1 | 1 | Nomb| 2 | Nb |

我想知道是否有办法重命名表的所有字段,可能看起来像(我知道以下的sql不起作用)：

SELECT p.* as p*, pa.* as pa*, a.* as att*

FROM produit p

LEFT OUTER JOIN produit_attribut pa

ON p.id=pa.id_produit

LEFT OUTER JOIN attribut a

ON a.id=pa.id_attribut

ORDER BY p.id,a.id;

顺便说一句,我知道我可以这样做：

SELECT

p.id AS p_id,

p.titre AS p_titre,

p.description AS p_description,

p.prix AS p_prix,

p.text_detail AS p_text_detail,

p.img_petite AS p_img_petite,

p.img_grande AS p_img_grande,

pa.id_produit AS pa_id_produit,

pa.id_attribut AS pa_id_attribut,

a.id AS a_id,

a.description AS a_description,

a.valeur AS a_valeur,

a.abbreviation AS a_abbreviation

FROM produit p

LEFT OUTER JOIN produit_attribut pa

ON p.id=pa.id_produit

LEFT OUTER JOIN attribut a

ON a.id=pa.id_attribut

ORDER BY p_id,a_id;

但我想避免这种情况.

我希望请求是通用的,因为我将在Php中使用此请求,它是关于通用CRUD组件(和嵌套表).

有办法吗？