Looking for a MySQL query expert
Budget: $10 – $30 USD
We need to make three queries or procedure of MySQL.
1. With the given numeric, make an insert query with SHA2 algorithm applied. And salt(random number) needs to be created and inserted and applied. So we need to apply SHA2 algorithm of the user's entered number and the salt.
2. Making a select query of the user's entered number + the saved salt number and comparing the selected value and the saved password value from DB column
3. We have an existing plain password, and are going to apply SHA2 and salt(random number). So make an 'Update' query to apply SHA2 and salt for migration
We will provide a DB connection information of our DBMS so work on there.
1. With the given numeric, make an insert query with SHA2 algorithm applied. And salt(random number) needs to be created and inserted and applied. So we need to apply SHA2 algorithm of the user's entered number and the salt.
2. Making a select query of the user's entered number + the saved salt number and comparing the selected value and the saved password value from DB column
3. We have an existing plain password, and are going to apply SHA2 and salt(random number). So make an 'Update' query to apply SHA2 and salt for migration
We will provide a DB connection information of our DBMS so work on there.