- Categories:
String & Binary Functions (Cryptographic Hash)
SHA1 , SHA1_HEX¶
Returns a 40-character hex-encoded string containing the 160-bit SHA-1 message digest.
These functions are synonymous.
Syntax¶
SHA1(<msg>)
SHA1_HEX(<msg>)
Arguments¶
msg
A string expression, the message to be hashed.
Examples¶
SELECT sha1('Snowflake');
------------------------------------------+
SHA1('SNOWFLAKE') |
------------------------------------------+
fda76b0bcc1e87cf259b1d1e3271d76f590fb5dd |
------------------------------------------+
The data type of the output is string (VARCHAR
) and can be stored in a
VARCHAR
column:
Create and fill a table:
CREATE TABLE sha_table( v VARCHAR, v_as_sha1 VARCHAR, v_as_sha1_hex VARCHAR, v_as_sha1_binary BINARY, v_as_sha2 VARCHAR, v_as_sha2_hex VARCHAR, v_as_sha2_binary BINARY ); INSERT INTO sha_table(v) VALUES ('AbCd0'); UPDATE sha_table SET v_as_sha1 = SHA1(v), v_as_sha1_hex = SHA1_HEX(v), v_as_sha1_binary = SHA1_BINARY(v), v_as_sha2 = SHA2(v), v_as_sha2_hex = SHA2_HEX(v), v_as_sha2_binary = SHA2_BINARY(v) ;Here are the query and output:
SELECT v, v_as_sha1, v_as_sha1_hex FROM sha_table ORDER BY v; +-------+------------------------------------------+------------------------------------------+ | V | V_AS_SHA1 | V_AS_SHA1_HEX | |-------+------------------------------------------+------------------------------------------| | AbCd0 | 9ddb991863d53b35a52c490db256207c776ab8d8 | 9ddb991863d53b35a52c490db256207c776ab8d8 | +-------+------------------------------------------+------------------------------------------+