This sample illustrates use of CREATE TABLE statement with MEMORY option.
This SQL script contains nine queries.
First one deletes table named "developers".
The second creates this table in-memory with 3 fields.
Queries 3-8 insert some data into the table.
The ninth query retrieves all rows from this table.
drop table memory developers;
create table memory developers (id AutoInc, code Integer, name varchar(20));
insert into memory developers (code, name) values (5, 'Bob');
insert into memory developers (code, name) values (7, 'Jeck');
insert into memory developers (code, name) values (2, 'Carol');
insert into memory developers (code, name) values (5, 'Harry');
insert into memory developers (code, name) values (4, 'Sam');
insert into memory developers (code, name) values (9, 'Chris');
select * from memory developers order by name desc, code, id;
Download Absolute Database | Learn more |
