Perform Simple SQL Queries Against a Database

Question 1

Perform Simple SQL Queries Against a Database

Answer 1

mysql -u root -p

SHOW DATABASES;

USE emails;
SHOW TABLES;
DESCRIBE users;

INSERT INTO users (userID, UserFirstName, UserLastName, userEmailAddress) VALUES (0001, “John”, “Smith”, “johnsmith@example.com”);

DESCRIBE users;

SELECT * FROM users

DELETE FROM users WHERE userID=2;

UPDATE users SET userLastName=”Jones”, userEmailAddress=”janejones@example.com” WHERE userID=2;

create user dick@”localhost” identified by “password”;

grant select on test.* to tom@’localhost’;