使用SQL关键字作为列的别名 [英] Use SQL keyword as alias name of a column

问题描述

我正在执行以下查询，但它给出语法错误.因为关键字key已在SQL中注册

I'm executing the following query but it is giving syntax error. Because the keyword key is registered in SQL

SELECT `id` AS key, `country_name` AS value FROM countries

我也尝试使用这样的方括号，但不起作用:

I also tried using brackets like this but it's not working:

SELECT `id` AS [key], `country_name` AS value FROM countries

如何处理?

推荐答案

使用 backtick(`)或单引号(')给出MySQL中列的别名

Use backtick(`) or Single Quote(') to give alias name of column in MySQL.

尝试一下:

SELECT `id` AS 'key', `country_name` AS value 
FROM countries;

OR

SELECT `id` AS `key`, `country_name` AS value 
FROM countries;

这篇关于使用SQL关键字作为列的别名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！