Question: First, create a MySQL database or use an existing database ( make sure to use a UTF 8 character set, like utf 8 mb 4

First, create a MySQL database or use an existing database (make sure to use a UTF8 character set, like utf8mb4) and then create a table in the database called "Ages":
CREATE TABLE Ages (`name` VARCHAR(128), age INTEGER );
Then make sure the table is empty by deleting any rows that you previously inserted, and insert these rows and only these rows with the following commands:
DELETE FROM Ages; INSERT INTO Ages (`name`, age) VALUES ('Harikrishna',17); INSERT INTO Ages (`name`, age) VALUES ('Aislinn',30); INSERT INTO Ages (`name`, age) VALUES ('Dharam',30); INSERT INTO Ages (`name`, age) VALUES ('Tian',35);
Once the inserts are done, run the following SQL command:
SELECT sha1(CONCAT(`name`,age)) AS X FROM Ages ORDER BY X;
Find thefirstrow in the resulting record set and enter the long string that lookslike254c6127cdbc4c38e065317667340e8b0950046f(this is just a sample string).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!