如何在 sql 查询中创建空白/硬编码列? [英] How can I create a blank/hardcoded column in a sql query?

问题描述

我想要一个查询，其中的列是硬编码值而不是来自表，可以这样做吗?我基本上需要它作为占位符，稍后我会回来填写.

I want have a query with a column that is a hardcoded value not from a table, can this be done? I need it basically as a placeholder that I am going to come back to later and fill in.

示例:

SELECT
hat,
shoe,
boat,
somevalue = 0 as placeholder
FROM
objects

然后我稍后会遍历这个查询并填写占位符

then I would loop through this query later and fill in the placeholder

在这个例子中 someValue 不是对象中的字段，我需要伪造它.我在冷融合中这样做并使用两个数据源来完成一个查询.我已经尝试了 space() 函数，但无法让它工作.

in this example someValue is not a field in objects, I need to fake it. I am doing this in coldfusion and using two datasources to complete one query. I have tried the space() function but have been unable to get it to work.

谢谢.

推荐答案

SELECT
    hat,
    shoe,
    boat,
    0 as placeholder
FROM
    objects

而 '' 作为占位符 用于字符串.

这篇关于如何在 sql 查询中创建空白/硬编码列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！