Author Archives: user

SQLite – ATTACH Database Consider a case when you have multiple databases available and you want to use any one of them at a time. SQLite ATTACH DATABASE statement is used to select a particular database, and after this command, all SQLite statements will be executed under the attached database. Syntax Following is the basic […]

SQLite – CREATE Database In SQLite, sqlite3 command is used to create a new SQLite database. You do not need to have any special privilege to create a database. Syntax Following is the basic syntax of sqlite3 command to create a database: − $sqlite3 DatabaseName.db Always, database name should be unique within the RDBMS. Example […]

SQLite – Syntax SQLite is followed by unique set of rules and guidelines called Syntax. This chapter lists all the basic SQLite Syntax. Case Sensitivity The important point to be noted is that SQLite is case insensitive, i.e. the clauses GLOB and glob have the same meaning in SQLite statements. Comments SQLite comments are extra […]