如何使用 MySQL SELECT 创建虚拟列?
- 作者: 可爱FFFF
- 来源: 51数据库
- 2022-11-01
问题描述
如果我做 SELECT a AS b 并且 b 不是表中的列，查询会创建虚拟"列吗?
If I do SELECT a AS b and b is not a column in the table, would query create the "virtual" column?
事实上，我需要将一些虚拟列合并到查询中，并将一些信息处理到查询中，以便我以后可以将其用于每个项目.
in fact, I need to incorporate some virtual column into the query and process some information into the query so I can use it with each item later on.
推荐答案
类似:
SELECT id, email, IF(active = 1, 'enabled', 'disabled') AS account_status FROM users
这允许您进行操作并将其显示为列.
This allows you to make operations and show it as columns.
您还可以使用连接并将操作显示为列:
you can also use joins and show operations as columns:
SELECT u.id, e.email, IF(c.id IS NULL, 'no selected', c.name) AS country FROM users u LEFT JOIN countries c ON u.country_id = c.id
推荐阅读
