开发者

Skipped command in SQLite expression: normal?

开发者 https://www.devze.com 2023-02-15 08:15 出处:网络
The following SQLite开发者_JAVA百科 query is accepted by the SQLite shell (version 3.7.5, which is the latest one), despite containing a \"strange\" insertion of the word qwerty:

The following SQLite开发者_JAVA百科 query is accepted by the SQLite shell (version 3.7.5, which is the latest one), despite containing a "strange" insertion of the word qwerty:

sqlite> select distinct DOB from (select * from MyTable qwerty);

It works whatever the word put after MyTable. Is this normal? I did not find this syntax in the syntax diagrams from the official sites.


You're aliassing the table MyTable as querty. Since you're not using either name in the rest of the query, this has no effect. The query is expressed by the documentation you linked, it's taking the path in single-source that skips database-name and AS.

0

精彩评论

暂无评论...
验证码 换一张
取 消