Open topic with navigation

About the NuoDB SQL History File

The nuosql utility, by default, stores all commands executed in the file $HOME/.nuosql.history. This file location can be overridden with the command line option --history. A typical .nuosql.history file would contain lines like these:

create table t (id int generated always as identity not null primary key, name varchar(10));
drop table t;
create table t (id int generated always as identity not null primary key, name varchar(10));
insert into t values (null, 'User1');
select * from t;
insert into t values (null, 'User2'), (null, 'User3');
select * from t;
create table t2 (id int generated always as identity not null primary key, name varchar(10));
drop table t2;
create table t2 (id int generated always as identity not null primary key, name varchar(10));
insert into t2 values (null, 'User1');
select * from system.properties;
help show
...

See Using Command Line History in NuoDB SQL for more information.