Create DataBase
CREATE DATABASE database_name
Create Table
CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)
InsertValues
INSERT INTO table_name
VALUES (value1, value2, value3,...)
like below
INSERT INTO Persons
VALUES (4,'Nilsen', 'Johan', 'Bakken 2', 'Stavanger')
DeleteValues
DELETE FROM table_name
WHERE some_column=some_value
like below
DELETE FROM Persons
WHERE LastName='Tjessem' AND FirstName='Jakob'
UpdateValues
UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value
-------------------------------------------------------------------------------------------------------------
2.
SQLiteOpenHelper
SQLiteOpenHelper is Superclass ,Which is use for Database Operations
No comments:
Post a Comment