通过查询更改SQL列标题 [英] Changing a SQL column title via query

问题描述

我有以下查询:

SELECT product_description.name, product.quantity,product.price,product_option_value_description.name,product_option_value.quantity
FROM product
INNER JOIN product_description
ON product.product_id=product_description.product_id
INNER JOIN product_option_value_description
ON product.product_id=product_option_value_description.product_id
INNER JOIN product_option_value
ON product.product_id=product_option_value.product_id
ORDER BY product_description.name 

我要如何为product_option_value_description.name更改标题，因为我想将此选项命名.

How could I change the title for product_option_value_description.name as I would like to name this option.

推荐答案

使用这样的别名:

product_option_value_description.name AS `Option`

如果要更改列名，不仅要用于此查询，而且通常要使用更改表

If you want to change the column's name, not only for this query but in general use ALTER TABLE

ALTER TABLE product_option_value_description CHANGE name newname DATATYPE;

这篇关于通过查询更改SQL列标题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！