CREATE EXTENSION pgcrypto;
INSERT INTO users (email, password) VALUES (
'johndoe@mail.com',
crypt('johnspassword', gen_salt('bf'))
);
SELECT id
FROM users
WHERE email = 'johndoe@mail.com'
AND password = crypt('johnspassword', password);| Code Example |
|---|
| Sql :: drop a recordin sql |
| Sql :: sqlalchemy return id after insert |
| Sql :: if null mysql |
| Sql :: print hello world in plsql |
| Sql :: oracle apex charging debug |
| Sql :: get foreign table names mysql |
| Sql :: postgres extract day from date |
| Sql :: desc in sql |
| Sql :: drop all tables in azure sql database |
| Sql :: postgresql contains |
| Sql :: primary key multiple |
| Sql :: adding constraints to columns SQL |
| Sql :: mysql export database command line |
| Sql :: update with inner join sql server |
| Sql :: mysql if condition |
| Sql :: mysql regexp match word |
| Sql :: psql load dump |
| Sql :: inner join distinct |
| Sql :: mysql delete database |
| Sql :: postgres like case insensitive |
| Sql :: oracle index size calculation |
| Sql :: postgres top 10 |
| Sql :: postgresql import data from csv |
| Sql :: sql select min row |
| Sql :: rename column name sql server |
| Sql :: how to select random rows from a table |
| Sql :: sql server split string last |
| Sql :: how to get initials in sql |
| Sql :: mysql regex exact match |
| Sql :: sql delete duplicate |