monetdb

http://www.monetdb.org/Documentation

console commands
db status 조회
$ sudo monetdb status
db 정지 & 삭제
$ sudo monetdb stop [database name]
$ sudo monetdb destroy -f [database name]
db 생성
$ sudo monetdb create [database name]
$ sudo monetdb start [database name]
$ sudo monetdb release [database name]
sql bulk 입력
$ mclient -h [server ip or name] -p [port number] -d [database name] -s [sql sentence]
$ mclient -h [server ip or name] -p [port number] -d [database name] < [sql file name]

system variable
sql>select * from var();
table 이름 보기
sql>select * from tables where system=false;
timestamp 형식 비교시 ''에 그대로 형식에 맞춰 쓰면 됨
sql>select * from [table name] where [filed name] > '2012-01-01 12:00:00.000';
string 길이: length()
sql>select * from [table name] where length([field name]) > [number];

$ mclient -d [database name]
sql>\?            (help)
sql>\q            (quit)
sql>\d            (show tables)
sql>\d [table name]            (desc table_name)