SQL Reference of 1DbManager 3.0
-------------------------------

Create a table
CREATE TABLE tableName
(
columnName1 dataType,
columnName2 dataType,
.......)

Create index
CREATE UNIQUE INDEX indexName
ON tableName (columnName)

Delete index
DROP INDEX tableName.indexName

Delete table
DROP TABLE tableName

Select
SELECT columnName(s) FROM tableName

Select with GroupBy
SELECT column,SUM(column) FROM table GROUP BY column

Insert new rows
INSERT INTO tableName (column1, column2,...)
VALUES (value1, value2,....)

Update 
UPDATE tableName SET columnName = newValue
WHERE columnName = someValue

Delete rows
DELETE FROM tableName WHERE columnName = someValue

___________________________________________
Comersus Sophisticated Software
8345 NW 66TH ST #3537 
Miami FL 33166-2626 United States
Phone: 1 (305) 735-8008
http://www.comersus.com