Help for this page

Select Code to Download

Select or download this

CREATE TABLE mytable (
    id INTEGER PRIMARY KEY,
...
    data TEXT,
    UNIQUE(element, items, item, data)
);

Select or download this

sqlite> SELECT ("element" || "/" || "items" || "/" || "item" || "/" ||
+ "data") AS source where source like '%some string%';