Skip to content

Latest commit

 

History

History
24 lines (16 loc) · 668 Bytes

SQL-Padding-Encryption.md

File metadata and controls

24 lines (16 loc) · 668 Bytes

You are given a table with the following format:

encryption table schema

  • md5
  • sha1
  • sha256

Problem is the table looks so unbalanced - the sha256 column contains much longer strings. You need to balance things up. Add '1' to the end of the md5 addresses as many times as you need to to make them the same length as those in the sha256 column. Add '0' to the beginning of the sha1 values to achieve the same result.

Return as:

output table schema

  • md5
  • sha1
  • sha256
/*  SQL  */
SELECT CONCAT(md5, REPEAT('1', LENGTH(sha256) - LENGTH(md5))) as md5, CONCAT(REPEAT('0', LENGTH(sha256)- LENGTH(sha1)), sha1) as sha1, sha256
FROM encryption;