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
.
精彩评论