开发者

Skipped command in SQLite expression: normal?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜