To get credit for this assignment, perform the instructions below and enter the code you get from the instructions below here (Hint: starts with 360) Instructions 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 ('Deelan', 37); INSERT INTO Ages (`name`, age) VALUES ('Denver', 33); INSERT INTO Ages (`name`, age) VALUES ('Rona', 23); INSERT INTO Ages (`name`, age) VALUES ('Kodi', 29); INSERT INTO Ages (`name`, age) VALUES ('Seaan', 18); Once the inserts are done, run the following SQL command:SELECT sha1(CONCAT(`name`,age)) AS X FROM Ages ORDER BY X; Find the first row in the resulting record set and enter the long string that looks like 254c6127cdbc4c38e065317667340e8b0950046f (this is just a sample string).
To get credit for this assignment, perform the instructions below and enter the code you get from the instructions below here (Hint: starts with 360)
Instructions
First, create a MySQL
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 ('Deelan', 37); INSERT INTO Ages (`name`, age) VALUES ('Denver', 33); INSERT INTO Ages (`name`, age) VALUES ('Rona', 23); INSERT INTO Ages (`name`, age) VALUES ('Kodi', 29); INSERT INTO Ages (`name`, age) VALUES ('Seaan', 18); Once the inserts are done, run the following SQL command:SELECT sha1(CONCAT(`name`,age)) AS X FROM Ages ORDER BY X; Find the first row in the resulting record set and enter the long string that looks like 254c6127cdbc4c38e065317667340e8b0950046f (this is just a sample string).
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
