找到了答案:
CREATE TRIGGER IF NOT EXISTS "prevent_duplicate_emails"BEFORE INSERT OF "email" ON "users"FOR EACH ROWBEGIN SELECt RAISE(ABORT, 'Email already exists.') WHERe EXISTS (SELECT 1 FROM "unique_emails" WHERe "email" LIKE NEW."email"); INSERT INTO "unique_emails" VALUES (NEW."email");END;



