Programmer's Blog

Programmer's reference

Category Archives: NuoDB

[NuoDB] Create Primary key with sequence

Create table <table_name> (id INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY (tst_seq));

[NuoDB] Find the next value of the sequence

select next value for <sequence name> from dual;

[NuoDB] Run sql files

$nuosql <dbname> --file <filename> --password <password>

e.g.
$nuosql test --file command_filename --password password

[NuoDB] Login to nuosql

Firstly ensure that the paths are exported
then use
$nuosql <dbname>@<hostaddr> --user <user_id> --password <passwd>

example for test database:
$nuosql test@localhost --user dba --password goalie