MySQL.md

MySQL

---

Install

Amazon Linux 2023

sudo dnf install -y mariadb105

Amazon Linux 2

sudo yum install -y mariadb

---

connect

# Export
ENDPOINT_URL="<DB_ENDPOINT>"
PORT="<PORT>" # Default Port Number : 3306
USER_NAME="<USER_NAME>"

# Connect
mysql -h $ENDPOINT_URL -P $PORT -u $USER_NAME -p

---

DataBase Example

Create DataBase

CREATE DATBASE demo;
USE demo;

Create Table

CREATE TABLE user_table (
    user_id INT NOT NULL AUTO_INCREMENT,
    user_name VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    PRIMARY KEY(user_id)
);

Add Data in Table

INSERT INTO user_table(user_name, password) VALUES ('admin', 'Skil39!@#');

Select Table

SELECT * FROM user_table;

Update Data in Table

UPDATE user_table SET password = 'Skill53##' WEHETE user_name = 'admin';

Delete Data in Table

DELETE FROM user_table WHERE user_name = 'admin';