SQLite – VACUUM VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. This eliminates free pages, aligns table data to be contiguous, and otherwise cleans up the database file structure. VACUUM command may change the ROWID of entries in tables […]
Author Archives: user
SQLite – Date & Time SQLite supports five date and time functions as follows − Sr.No. Function Example 1 date(timestring, modifiers…) This returns the date in this format: YYYY-MM-DD 2 time(timestring, modifiers…) This returns the time as HH:MM:SS 3 datetime(timestring, modifiers…) This returns YYYY-MM-DD HH:MM:SS 4 julianday(timestring, modifiers…) This returns the number of days since […]
SQLite – Subqueries A Subquery or Inner query or Nested query is a query within another SQLite query and embedded within the WHERE clause. A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved. Subqueries can be used with […]