mysql中的dual表

来源:互联网 发布:mac如何压缩图片大小 编辑:程序博客网 时间:2024/05/17 01:13
mysql文档中对于dual表的解释:

You are allowed to specify DUAL as a dummy table name in situations where no tables are referenced:
mysql> SELECT 1 + 1 FROM DUAL;
-> 2

DUAL is purely for the convenience of people who require that all SELECT statements should have FROM and possibly other clauses. MySQL may ignore the clauses. MySQL does not require FROM DUAL if no tables are referenced.



0 0
原创粉丝点击