Go ahead and run the below query into your "users" table. You just need to copy and paste it. 2- write a query to select all data with "mypass" password (first_name, last_name, email, pass, registration_date) VALUES ('Larry', 'Ullman', 'email@example.com', SHA1('mypass'), NOW()); INSERT INTO users VALUES (NULL, 'Zoe', 'Isabella', 'email2@example.com', SHA1('mojito'), NOW()); INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('John', 'Lennon', 'john@beatles.com', SHA1('Happin3ss'), NOW()),('Paul', 'McCartney', 'paul@beatles.com', SHA1('letITbe'), NOW()),('George', 'Harrison', 'george@beatles.com ', SHA1('something'), NOW()),('Ringo', 'Starr', 'ringo@beatles.com', SHA1('thisboy'), NOW()); INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('David', 'Jones', 'davey@monkees.com', SHA1('fasfd'), NOW()),('Peter', 'Tork', 'peter@monkees.com', SHA1('warw'), NOW()),('Micky', 'Dolenz', 'micky@monkees.com ', SHA1('afsa'), NOW()),('Mike', 'Nesmith', 'mike@monkees.com', SHA1('abdfadf'), NOW()),('David', 'Sedaris', 'david@authors.com', SHA1('adfwrq'), NOW()),('Nick', 'Hornby', 'nick@authors.com', SHA1('jk78'), NOW()),('Melissa', 'Bank', 'melissa@authors.com', SHA1('jhk,h'), NOW()),('Toni', 'Morrison', 'toni@authors.com', SHA1('hdhd'), NOW()),('Jonathan', 'Franzen', 'jonathan@authors.com', SHA1('64654'), NOW()),('Don', 'DeLillo', 'don@authors.com', SHA1('asf8'), NOW()),('Graham', 'Greene', 'graham@authors.com', SHA1('5684eq'), NOW()),('Michael', 'Chabon', 'michael@authors.com', SHA1('srw6'), NOW()),('Richard', 'Brautigan', 'richard@authors.com', SHA1('zfs654'), NOW()),('Russell', 'Banks', 'russell@authors.com', SHA1('wwr321'), NOW()),('Homer', 'Simpson', 'homer@simpson.com', SHA1('5srw651'), NOW()),('Marge', 'Simpson', 'marge@simpson.com', SHA1('ljsa'), NOW()),('Bart', 'Simpson', 'bart@simpson.com', SHA1('pwqojz'), NOW()),('Lisa', 'Simpson', 'lisa@simpson.com', SHA1('uh6'), NOW()),('Maggie', 'Simpson', 'maggie@simpson.com', SHA1('plda664'), NOW()),('Abe', 'Simpson', 'abe@simpson.com', SHA1('qopkrokr65'), NOW())
Go ahead and run the below query into your "users" table. You just need to copy and paste it. 2- write a query to select all data with "mypass" password (first_name, last_name, email, pass, registration_date) VALUES ('Larry', 'Ullman', 'email@example.com', SHA1('mypass'), NOW()); INSERT INTO users VALUES (NULL, 'Zoe', 'Isabella', 'email2@example.com', SHA1('mojito'), NOW()); INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('John', 'Lennon', 'john@beatles.com', SHA1('Happin3ss'), NOW()),('Paul', 'McCartney', 'paul@beatles.com', SHA1('letITbe'), NOW()),('George', 'Harrison', 'george@beatles.com ', SHA1('something'), NOW()),('Ringo', 'Starr', 'ringo@beatles.com', SHA1('thisboy'), NOW()); INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('David', 'Jones', 'davey@monkees.com', SHA1('fasfd'), NOW()),('Peter', 'Tork', 'peter@monkees.com', SHA1('warw'), NOW()),('Micky', 'Dolenz', 'micky@monkees.com ', SHA1('afsa'), NOW()),('Mike', 'Nesmith', 'mike@monkees.com', SHA1('abdfadf'), NOW()),('David', 'Sedaris', 'david@authors.com', SHA1('adfwrq'), NOW()),('Nick', 'Hornby', 'nick@authors.com', SHA1('jk78'), NOW()),('Melissa', 'Bank', 'melissa@authors.com', SHA1('jhk,h'), NOW()),('Toni', 'Morrison', 'toni@authors.com', SHA1('hdhd'), NOW()),('Jonathan', 'Franzen', 'jonathan@authors.com', SHA1('64654'), NOW()),('Don', 'DeLillo', 'don@authors.com', SHA1('asf8'), NOW()),('Graham', 'Greene', 'graham@authors.com', SHA1('5684eq'), NOW()),('Michael', 'Chabon', 'michael@authors.com', SHA1('srw6'), NOW()),('Richard', 'Brautigan', 'richard@authors.com', SHA1('zfs654'), NOW()),('Russell', 'Banks', 'russell@authors.com', SHA1('wwr321'), NOW()),('Homer', 'Simpson', 'homer@simpson.com', SHA1('5srw651'), NOW()),('Marge', 'Simpson', 'marge@simpson.com', SHA1('ljsa'), NOW()),('Bart', 'Simpson', 'bart@simpson.com', SHA1('pwqojz'), NOW()),('Lisa', 'Simpson', 'lisa@simpson.com', SHA1('uh6'), NOW()),('Maggie', 'Simpson', 'maggie@simpson.com', SHA1('plda664'), NOW()),('Abe', 'Simpson', 'abe@simpson.com', SHA1('qopkrokr65'), NOW())
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 52P
Related questions
Question
Go ahead and run the below query into your "users" table. You just need to copy and paste it.
2- write a query to select all data with "mypass" password
(first_name, last_name, email, pass, registration_date) VALUES ('Larry', 'Ullman', 'email@example.com', SHA1('mypass'), NOW());
INSERT INTO users VALUES (NULL, 'Zoe', 'Isabella', 'email2@example.com', SHA1('mojito'), NOW());
INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('John', 'Lennon', 'john@beatles.com', SHA1('Happin3ss'), NOW()),('Paul', 'McCartney', 'paul@beatles.com', SHA1('letITbe'), NOW()),('George', 'Harrison', 'george@beatles.com ', SHA1('something'), NOW()),('Ringo', 'Starr', 'ringo@beatles.com', SHA1('thisboy'), NOW());
INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('David', 'Jones', 'davey@monkees.com', SHA1('fasfd'), NOW()),('Peter', 'Tork', 'peter@monkees.com', SHA1('warw'), NOW()),('Micky', 'Dolenz', 'micky@monkees.com ', SHA1('afsa'), NOW()),('Mike', 'Nesmith', 'mike@monkees.com', SHA1('abdfadf'), NOW()),('David', 'Sedaris', 'david@authors.com', SHA1('adfwrq'), NOW()),('Nick', 'Hornby', 'nick@authors.com', SHA1('jk78'), NOW()),('Melissa', 'Bank', 'melissa@authors.com', SHA1('jhk,h'), NOW()),('Toni', 'Morrison', 'toni@authors.com', SHA1('hdhd'), NOW()),('Jonathan', 'Franzen', 'jonathan@authors.com', SHA1('64654'), NOW()),('Don', 'DeLillo', 'don@authors.com', SHA1('asf8'), NOW()),('Graham', 'Greene', 'graham@authors.com', SHA1('5684eq'), NOW()),('Michael', 'Chabon', 'michael@authors.com', SHA1('srw6'), NOW()),('Richard', 'Brautigan', 'richard@authors.com', SHA1('zfs654'), NOW()),('Russell', 'Banks', 'russell@authors.com', SHA1('wwr321'), NOW()),('Homer', 'Simpson', 'homer@simpson.com', SHA1('5srw651'), NOW()),('Marge', 'Simpson', 'marge@simpson.com', SHA1('ljsa'), NOW()),('Bart', 'Simpson', 'bart@simpson.com', SHA1('pwqojz'), NOW()),('Lisa', 'Simpson', 'lisa@simpson.com', SHA1('uh6'), NOW()),('Maggie', 'Simpson', 'maggie@simpson.com', SHA1('plda664'), NOW()),('Abe', 'Simpson', 'abe@simpson.com', SHA1('qopkrokr65'), NOW())
INSERT INTO users VALUES (NULL, 'Zoe', 'Isabella', 'email2@example.com', SHA1('mojito'), NOW());
INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('John', 'Lennon', 'john@beatles.com', SHA1('Happin3ss'), NOW()),('Paul', 'McCartney', 'paul@beatles.com', SHA1('letITbe'), NOW()),('George', 'Harrison', 'george@beatles.com ', SHA1('something'), NOW()),('Ringo', 'Starr', 'ringo@beatles.com', SHA1('thisboy'), NOW());
INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('David', 'Jones', 'davey@monkees.com', SHA1('fasfd'), NOW()),('Peter', 'Tork', 'peter@monkees.com', SHA1('warw'), NOW()),('Micky', 'Dolenz', 'micky@monkees.com ', SHA1('afsa'), NOW()),('Mike', 'Nesmith', 'mike@monkees.com', SHA1('abdfadf'), NOW()),('David', 'Sedaris', 'david@authors.com', SHA1('adfwrq'), NOW()),('Nick', 'Hornby', 'nick@authors.com', SHA1('jk78'), NOW()),('Melissa', 'Bank', 'melissa@authors.com', SHA1('jhk,h'), NOW()),('Toni', 'Morrison', 'toni@authors.com', SHA1('hdhd'), NOW()),('Jonathan', 'Franzen', 'jonathan@authors.com', SHA1('64654'), NOW()),('Don', 'DeLillo', 'don@authors.com', SHA1('asf8'), NOW()),('Graham', 'Greene', 'graham@authors.com', SHA1('5684eq'), NOW()),('Michael', 'Chabon', 'michael@authors.com', SHA1('srw6'), NOW()),('Richard', 'Brautigan', 'richard@authors.com', SHA1('zfs654'), NOW()),('Russell', 'Banks', 'russell@authors.com', SHA1('wwr321'), NOW()),('Homer', 'Simpson', 'homer@simpson.com', SHA1('5srw651'), NOW()),('Marge', 'Simpson', 'marge@simpson.com', SHA1('ljsa'), NOW()),('Bart', 'Simpson', 'bart@simpson.com', SHA1('pwqojz'), NOW()),('Lisa', 'Simpson', 'lisa@simpson.com', SHA1('uh6'), NOW()),('Maggie', 'Simpson', 'maggie@simpson.com', SHA1('plda664'), NOW()),('Abe', 'Simpson', 'abe@simpson.com', SHA1('qopkrokr65'), NOW())
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning