如何使用 MySQL SELECT 创建虚拟列?

How to create virtual column using MySQL SELECT?(如何使用 MySQL SELECT 创建虚拟列?)
本文介绍了如何使用 MySQL SELECT 创建虚拟列?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

如果我做 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

这篇关于如何使用 MySQL SELECT 创建虚拟列?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

In PHP how can you clear a WSDL cache?(在 PHP 中如何清除 WSDL 缓存?)
failed to open stream: HTTP wrapper does not support writeable connections(无法打开流:HTTP 包装器不支持可写连接)
Stop caching for PHP 5.5.3 in MAMP(在 MAMP 中停止缓存 PHP 5.5.3)
Caching HTTP responses when they are dynamically created by PHP(缓存由 PHP 动态创建的 HTTP 响应)
Memcached vs APC which one should I choose?(Memcached 与 APC 我应该选择哪一个?)
What is causing quot;Unable to allocate memory for poolquot; in PHP?(是什么导致“无法为池分配内存?在 PHP 中?)