sqlite - Fts Usage

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 31,37 ****
  
  Destroying an =fts= table uses the standard SQLite {link: http://www.sqlite.org/lang_droptable.html DROP TABLE} syntax.
  
! **Accessing =fts= tables**
  
  =fts= tables are accessed using *SELECT*, *INSERT*, *UPDATE*, and *DELETE* statements exactly as regular SQLite tables.  The set of columns which can be referenced are exactly those enumerated in the create statement, all of which will appear to be of type TEXT.  The table has the implicit unique index on =rowid=, plus the full-text index (see next section), but otherwise allows for no indices.  A query such as:
  
--- 31,37 ----
  
  Destroying an =fts= table uses the standard SQLite {link: http://www.sqlite.org/lang_droptable.html DROP TABLE} syntax.
  
! **Accessing fts tables**
  
  =fts= tables are accessed using *SELECT*, *INSERT*, *UPDATE*, and *DELETE* statements exactly as regular SQLite tables.  The set of columns which can be referenced are exactly those enumerated in the create statement, all of which will appear to be of type TEXT.  The table has the implicit unique index on =rowid=, plus the full-text index (see next section), but otherwise allows for no indices.  A query such as: