INSERT | test.insert(1,"Hallo") |
insert test(id=1, name='Hallo') insert test(1,'Hallo') |
UPDATE |
test[id==1].update(name="Hallo") |
update test id=1 where name=='Hallo' |
DELETE |
test[id==1].delete() |
delete test where id==1 |
SELECT |
test[id==1].select() |
select test where id=1 |
CREATE TABLE |
test=new table( autoincrement id, string name, key(id), index(name) idxName ) |
create table test( id autoincrement, name string, primary key(id), index idxname(name) ) |
CREATE INDEX |
test.add(index idxName(name)) |
create index test.idxname(name) |
CREATE USER |
sys.users.insert("scott","tiger") |
create user scott password tiger |
GRANT |
sys.rights.put("scott","test","all") |
grant scott test, all |
DROP TABLE |
test.drop() |
drop test |
DROP INDEX |
test.dropIndex(idxname) |
drop test.idxname |
COMMIT |
commit() |
commit |
ROLLBACK |
rollback() |
rollback |
Data types |
boolean, int, long, string, date, time, timestamp,
binary, decimal, autoincrement |
boolean, int, long, string, date, time, timestamp,
binary, decimal, autoincrement, stream |
Conditions |
! || && == >= <= > < != |
not or and == >= <= > < <> |
Expressions |
+ - ( ) * / & | % |
+ - ( ) * / |