Re: [sqlite] Cannot make index for non-main database

The correct syntax is: CREATE INDEX dbondisk.diskIndex on TestTable (Parent) See: https://sqlite.org/lang_createindex.html On 2018/08/27 5:37 PM, Jiawei Duan wrote: SQLite version: 3.24.0 System info: macOS 10.13.6 The following SQL commands results an error of "Error: near ".": syntax erro

[sqlite] Cannot make index for non-main database

SQLite version: 3.24.0 System info: macOS 10.13.6 The following SQL commands results an error of "Error: near ".": syntax error”. However the command can proceed within the main database. ATTACH DATABASE ‘/Users/***/test.db' AS dbondisk; CREATE INDEX diskIndex on dbondisk.TestTable (Parent)