MySQL 通过查询更改 SQL 列标题
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6812600/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Changing a SQL column title via query
提问by Jess McKenzie
I have the following 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
How could I change the title for product_option_value_description.nameas I would like to name this option.
我如何更改标题，product_option_value_description.name因为我想命名此选项。
回答by Jacob
Use an alias like so:
像这样使用别名：
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
ALTER TABLE product_option_value_description CHANGE name newname DATATYPE;
回答by JK.
Just write product_option_value_description.name AS Nameto create the alias "Name"
for this column.
只需编写product_option_value_description.name AS Name为此列创建别名“名称”即可。
回答by NightWolf
Use as
用 as
For example:
例如：
SELECT product_description.name as 'ProdName', product.quantity,product.price,product_option_value_description.name as 'ProdDesc',product_option_value.quantity FROM product
回答by Orson DCunha
You can use any alias name using the 'AS' keyword. eg. select student_idAS idfrom student_info
您可以使用“AS”关键字使用任何别名。例如。从 student_info 中选择student_idAS id
