Firebird 2.1-简单选择 [英] Firebird 2.1 - Simple SELECT

问题描述

我想合并一些数据，但是一个简单的选择示例不起作用.选择现有表可以正常工作...

I would like to union some data, but a simple select example not working. Selecting existing tables work fine...

SELECT 1 as foo

消息:

can't format message 13:896 -- message file C:\xxxx\firebird.msg not found.
Dynamic SQL Error.
SQL error code = -104.
corrupt pool.

在MySQL和Postgres中，使用这些简单的选择没有问题.

In MySQL and Postgres is no problem with these simple select..

感谢帮助！

推荐答案

Firebird(与许多其他DBMS一样)需要FROM子句.在Oracle中，您可以使用DUAL表，在Firebird中，您可以使用RDB$DATABASE

Firebird (like many other DBMS) requires a FROM clause. In Oracle you'd use the DUAL table, in Firebird you can use RDB$DATABASE

SELECT 1 as foo
FROM RDB$DATABASE;

由于RDB$DATABASE始终只包含一行，因此它的工作方式与Oracle的DUAL表(或IBM的SYSDUMMY)

As RDB$DATABASE always contains exactly one row, this works the same way as Oracle's DUAL table (or IBM's SYSDUMMY)

这篇关于Firebird 2.1-简单选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！