• Home
• tech.aroma
• aroma-data-operations
• 2.1
• source code
• update_credential.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

tech.aroma.sql.inserts.update_credential.sql Maven / Gradle / Ivy

------------------------------------------------------------------------------
-- UPDATES A USER'S CREDENTIALS
------------------------------------------------------------------------------

INSERT INTO credentials (user_id, encrypted_password)
VALUES (?, ?)
ON CONFLICT (user_id)
    DO UPDATE
        SET encrypted_password = EXCLUDED.encrypted_password,
            time_created       = now()