CREATE TABLE comment (body TEXT, userid INTEGER, date TEXT); WITH cte(body, userid, date) AS (SELECT 'body1', 1, CURRENT_DATE) INSERT INTO comment (body, userid, date) SELECT c.* FROM cte c WHERE NOT EXISTS (SELECT * FROM comment t WHERE (t.body, t.userid) = (c.body, c.userid)) RETURNING rowid;
To embed this project on your website, copy the following code and paste it into your website's HTML: