This data as json, CSV (advanced)
docid ▲ | c0text1 | c1text2 | c2name with . and spaces | c3content |
---|---|---|---|---|
2 | terry dog | sara weasel | puma | |
1 | barry cat | terry dog | panther |
JSON shape: default, array, newline-delimited, object
CREATE TABLE 'searchable_fts_content'(docid INTEGER PRIMARY KEY, 'c0text1', 'c1text2', 'c2name with . and spaces', 'c3content');