SqLite Syntex




SqLite Syntex

SqLite – A relational databases?

As we already discussed earlior sqlite is a relational database management system.

A relational database management system can have following elements.

  • Database – a collection of related records, organized into tables
  • Table – a set of data elements (values) organized by records (horizontal rows) and fields (vertical columns)
  • Record (or row) – a single, structured data item in a table
  • Field (or column) – a set of data values of a particular simple type, one for each row of the table

Let’s Consider an example to Understand Sqlite database syntex. I say we have a database called School. In the School database we have a table called Student. The Student table contains student information as shown below:

The table Student contains information of seven students in seven rows. The Student table also contains five columns. (ID, NAME, SURNAME, AGE, ADDRESS).

SqLite Statements

SqLite statements enables us to interact with the data in the database.For example if we want to Fetch all the data form the table Student, we can write the following statement.


SqLite – case sensitive

SqLite is not case sensitive, and neither is the SQL standard. It’s just common practice to write the commands upper-case.

Now, if we talk about table or column names, then yes they are, but not the commands themselves.

So

is the same as

but not the same as


SqLite – List Of most frequently used keywords in SqLite

  • aggregate functions
  • ALTER TABLE
  • ANALYZE
  • ATTACH DATABASE
  • BEGIN TRANSACTION
  • comment
  • COMMIT TRANSACTION
  • core functions
  • CREATE INDEX
  • CREATE TABLE
  • CREATE TRIGGER
  • CREATE VIEW
  • CREATE VIRTUAL TABLE
  • date and time functions
  • DELETE
  • DETACH DATABASE
  • DROP INDEX
  • DROP TABLE
  • DROP TRIGGER
  • DROP VIEW
  • END TRANSACTION
  • EXPLAIN
  • expression
  • INDEXED BY
  • INSERT
  • keywords
  • ON CONFLICT clause
  • PRAGMA
  • REINDEX
  • RELEASE SAVEPOINT
  • REPLACE
  • ROLLBACK TRANSACTION
  • SAVEPOINT
  • SELECT
  • UPDATE
  • VACUUM
  • WITH clause

Partner Sites

VideoToGifs.com

EasyOnlineConverter.com

SqliteTutorials.com