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.