| 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 |
+ - ( ) * / & | % |
+ - ( ) * / |