home / fixtures / primary_key_edge_cases

Menu

primary_key_edge_cases

10 rows

View and edit SQL

Export data

primary_key_edge_cases

All rows in this table

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

id ▼ content
  null, first
  null, second
  null, third
1 integer 1
1.5 float 1.5
empty empty string
$null text $null
1 text 1
i:1 text i:1
binary 0102 binary 0102
Table schema
CREATE TABLE primary_key_edge_cases (
    id PRIMARY KEY,
    content TEXT
);
Powered by Datasette · Queries took 13.991ms