home / fixtures / compound_primary_key_edge_cases

Menu

compound_primary_key_edge_cases

6 rows

View and edit SQL

Export data

compound_primary_key_edge_cases

All rows in this table

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

Suggested facets
  • pk1
  • pk2
Link pk1 pk2 content
      two nulls
,     two empty strings
  a   a and null, first
  a   a and null, second
a, a   a and empty string
a,b a b a and b
Table schema
CREATE TABLE compound_primary_key_edge_cases (
    pk1 TEXT,
    pk2 TEXT,
    content TEXT,
    PRIMARY KEY (pk1, pk2)
);
Powered by Datasette · Queries took 14.648ms