Install
sudo dnf update -y
sudo dnf install -y mariadb105
Shell
복사
Connect
•
ENDPOINT_URL 및 USER_NAME(관리자) 변수를 설정
mysql -h $ENDPOINT_URL -P 3306 -u $USER_NAME -p
Shell
복사
Database Example
CREATE DATABASE demo;
USE demo;
Shell
복사
Table Example
CREATE TABLE member (
idx INT NOT NULL AUTO_INCREMENT,
user_id VARCHAR(20) NOT NULL,
password VARCHAR(20) NOT NULL,
PRIMARY KEY(idx)
);
CREATE TABLE employees (
emp_no INT NOT NULL,
birth_date DATE NOT NULL,
first_name VARCHAR(14) NOT NULL,
last_name VARCHAR(16) NOT NULL,
gender ENUM('M','F') NOT NULL,
hire_date DATE NOT NULL,
PRIMARY KEY (emp_no)
);
Shell
복사
CRUD Example
INSERT INTO member(user_id, password) VALUES ('admin', 'pw1234');
source insert.sql;
SELECT * FROM member;
UPDATE member SET password = 'pw5678' WHERE user_id = 'admin';
DELETE FROM member WHERE user_id = 'admin';
Shell
복사
Index Example
CREATE INDEX name ON employees (first_name, last_name);
Shell
복사
New User
CREATE USER 'admin'@'%' IDENTIFIED BY 'Mysql1234!';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Shell
복사