complex_foreign_keys

1 row where f3 = 1

Clear filters
View and edit SQL
complex_foreign_keys

Filtered rows where f3 = 1

TSV All 1 row
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 1 row
Comma-separated values, for spreadsheets and other tools
  • JSON All 1 row
    Rows inside an object, with extra details
    View Download
  • JSON array All 1 row
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 1 row
    One JSON object per line
    View Download
  • JSON object All 1 row
    Rows keyed by their primary key
    View Download
  • testall All 1 row
    View Download
  • testnone All 1 row
    View Download
  • testresponse All 1 row
    View Download

pk ▼ f1 f2 f3
1 hello 1 world 2 hello 1
Table schema 
CREATE TABLE "complex_foreign_keys" (
  pk varchar(30) primary key,
  f1 integer,
  f2 integer,
  f3 integer,
  FOREIGN KEY ("f1") REFERENCES [simple_primary_key](id),
  FOREIGN KEY ("f2") REFERENCES [simple_primary_key](id),
  FOREIGN KEY ("f3") REFERENCES [simple_primary_key](id)
);