Category Archives: sqlite

SQLite – Commands This chapter will take you through simple and useful commands used by SQLite programmers. These commands are called SQLite dot commands and exception with these commands is that they should not be terminated by a semi-colon (;). Let”s start with typing a simple sqlite3 command at command prompt which will provide you […]

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 […]

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 […]