123456789 |
- INSERT INTO goto (hash, content, qr, preview, created) VALUES (:hash, :content, :qr, json(:preview), CURRENT_TIMESTAMP)
- ON CONFLICT DO
- UPDATE SET
- content = excluded.content,
- created = excluded.created,
- qr = excluded.qr,
- preview = excluded.preview
- WHERE excluded.created > goto.created;
- SELECT 'dynamic' AS component, sqlpage.run_sql('sqlpage/link.sql') AS properties;
|