As we already discussed earlior sqlite is a relational database management system.
A relational database management system can have following elements.
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:
ID NAME SURNAME AGE ADDRESS ---------- ---------- ---------- ---------- ---------- 1 Mark Benson 21 Cologne 2 July Tesar 25 Munich 3 John Mankov 23 Berlin 4 Tom Muller 30 Hamburg 5 Patrik Nauer 24 Essen 6 Peter Borse 32 Manheim 7 Carl Rossman 36 Stuttgart
The table Student contains information of seven students in seven rows. The Student table also contains five columns. (ID, NAME, SURNAME, AGE, ADDRESS).
For example if we want to Fetch all the data form the table Student, we can write the following statement.
SELECT * FROM Student;
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.
SoSELECT * FROM foo;is the same as
select * from foo;but not the same as
select * from FOO;