SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Hint: use Ctrl+Enter for SQL autocomplete create table datavalues ( id serial primary key, value text -- json or any suitable type ); insert into datavalues (value) values ('Value1'), ('Value3'), ('Value10'); create table manydata ( id bigserial primary key, value_id int, inserted_at timestamp with time zone default current_timestamp, updated_at timestamp, foreign key (value_id) references datavalues(id) ); create index on manydata(value_id); insert into manydata (value_id) values (1), (2), (3), (1), (2), (3), (1), (2), (3); select * from manydata join datavalues on datavalues.id = manydata.value_id;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear