Jump to content

Frequently followed steps for SQLite database.


Markeloff

Recommended Posts

CREATE TABLE TABLE 
-- limiter 
SELECT column1, column2, ...., columnN OR just *  
FROM TABLE 
WHERE -- boolean expression or no where to show all. 
-- limiter 
UPDATE TABLE 
SET column1 = value1, column2 = value 2, ..., columnN = valueN 
-- limiter 
DELETE FROM TABLE 
WHERE -- boolean expression to tell SQLITE which row/s or w/e. 
-- limiter 
INSERT INTO TABLE(column1, column2, ...., columnN) 
VALUES (value1, value2, ..., valueN) 
  

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...