Sql Beginner); INSERT INTO users (username, email, password) VALUES ('Allan', 'allan@gmail.com', 'saaxcec')); INSERT INTO users (username, email...

INSTALLATION

https://docs.google.com/document/d/1RSgg6R0tbNiuN1TOYaP06dqG6YRgDJ4qJNoxkwcDdlg/edit?usp=sharing

• How do I go about installing MySQL?

• Link to Windows installation. To install the MySQL Shell, add the option of MySql Shell the same way they click to add the MySQL Workbench during the installation process. https://www.youtube.com/watch?v=BxdSUGBs0gM

• Link to Linux installation. :https://www.youtube.com/watch?v=zRfI79BHf3k

https://phoenixnap.com/kb/install-mysql-ubuntu-20--04

• Link to Mac installation. To install the shell just follow thesame procedure as the installation of the workbench. ::https://www.youtube.com/watch?v=ODNSrWSq7tw

• After installation ...

CREATE DATABASE db;

USE db;

CREATE TABLE users (

user_id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50)NOT NULL,

email VARCHAR(100) NOT NULL,

password VARCHAR (255) -- NO SEMICOLON

);

INSERT INTO users (username, email, password)

VALUES ('Allan', 'allan@gmail.com', 'saaxecec')

SELECT * FROM users;

SELECT item, amount FROM orders;

FROM orders

WHERE amount >= 20

ORDER BY amount DESC;

SELECT *

FROM orders

--wildcards

WHERE item LIKE 'ch%'; -- everything with ch

____ 4 underscores -- everything with 4 characters