SQLite
SQLite
CSE373
Outline
Introduction to SQL SQLite SQLite Shell SQLite From A Program
An example in Java
Conclusions
SQL
Quick Introduction To SQL
The Structured Query Language (SQL) is a programming language designed to interact with relational databases
The SQL anagram can be pronounced either S-Q-L or sequel
SQL is designed to work with databases that are composed of tables
The columns are data typed fields The rows are instances of data Relationships can be established between the columns of tables
The formal description of the names and structure of the tables in a database is called a schema
Often the schema is the series of SQL statements that create the tables, relationships and constraints
Quick Introduction To SQL
There are four basic functions of any storage system (CRUD)
Create Read Update Delete
The statements in SQL that support CRUD are:
CREATE TABLE - Create INSERT - Create SELECT - Read UPDATE ? Update ALTER TABLE - Update DELETE ? Delete DROP - Delete
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.