MySQL 명령어 정리

CREATE TABLE <테이블 이름> (
	id VARCHAR(255),
    name VARCHAR(255)
)

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)
);

curl -X POST <URL>/v1/employee \
     -H "Content-Type: application/json" \
     -d '{
           "emp_no": 500001,
           "birth_date": "1957-05-02",
           "first_name": "dbdump",
           "last_name": "dbdump",
           "gender": "M",
           "hire_date": "1997-11-30"
         }'

curl -w "%{http_code}\n"  -s "<URL>/v1/employee?first_name=dbdump&last_name=dbdump"

curl -X POST -w "%{http_code}\n" -H "Content-Type: application/json" -d '{"length": 256}' -s "<URL>"

curl -X POST -w "%{http_code}\n" -H "Content-Type: application/json" -d '{"hello": 256}' -s "<URL>"

.dump 파일 데이터를 DB에 삽입 <Ec2에서 실행>

mysql -u <사용자> -p -h <앤드포인트> <테이블> < ./load_employees.dump

14400

aws rds describe-db-clusters --db-cluster-identifier wsc2024-db-cluster --query 'DBClusters[0].EngineVersion' --output text \
; aws rds describe-db-clusters --db-cluster-identifier wsc2024-db-cluster --query 'DBClusters[0].MasterUsername' --output text \
; aws rds describe-db-instances  --query "DBInstances[?DBClusterIdentifier=='wsc2024-db-cluster'].DBInstanceClass" --output text
aws rds describe-db-clusters --db-cluster-identifier wsc2024-db-cluster --query "DBClusters[0].BacktrackWindow" --output text