Note: Text inside [ ] is optional. Text inside < > should be replaced.
INSERT INTO < table_name>
[ ( < column_list> ) ]
VALUES ( <expression> [ ,... n] )
Examples:
INSERT INTO FILTER VALUES (‘Filter for only second shift’, ‘Filter01’)
INSERT INTO FILTER (FILENAME, NAME) VALUES (‘Filter01’, ‘Filter for only second shift’)
DELETE FROM < table_name>
[ WHERE < search_condition> ]
Examples:
DELETE FROM FILTER
DELETE FROM FILTER WHERE FILENAME = ‘Filter01’
UPDATE < table_name>
SET < column_name> = <expression> [ ,... n ]
[ WHERE < search_condition> ]
Examples:
UPDATE FILTER SET FILENAME = ‘Filter01’ WHERE NAME = ‘Filter for only second shift’
UPDATE FILTER SET FILENAME = ‘Filter01’, FILENAME = ‘Filter for only second shift’ WHERE FILENAME = ‘Filter02’
SELECT [< select_list> | DISTINCT ]
[ FROM < table_source> [ ,... n ] ]
[ WHERE < search_condition> ]
[ GROUP BY [ ALL ] < group_by_expression> [ ,... n ] ]
[ ORDER BY < order_by_expression> [ ASC | DESC ] [ ,... n ] ]
Examples:
SELECT * FROM FILTER
SELECT NAME,FILENAME FROM FILTER WHERE NAME = ‘Filter01’ AND FILENAME = ‘Filter for only second shift’
SELECT DISTINCT NAME, COUNT(NAME) FROM FILTER GROUP BY NAME
SELECT * FROM FILTER ORDER BY NAME DESC