1 #!/bin/bash yum -y install httpd systemctl enable httpd systemctl start httpd echo '

AWS Web Server!

' > /var/www/html/index.html dnf install mariadb105 -y 2 mysql -h database-1.cp6ogukc8u58.ap-northeast-2.rds.amazonaws.com -P 3306 -u admin -p Enter password: 3 -- 데이터베이스 선택 (기존 DB 사용 또는 새로 생성) CREATE DATABASE IF NOT EXISTS test_db; USE test_db; -- 학생 정보 테이블 생성 CREATE TABLE students ( student_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL, email VARCHAR(100) UNIQUE, age INT, major VARCHAR(50), gpa DECIMAL(3, 2), enrollment_date DATETIME DEFAULT CURRENT_TIMESTAMP ); -- 테이블 구조 확인 DESCRIBE students; 4 -- 단일 데이터 추가 INSERT INTO students (name, email, age, major, gpa) VALUES ('김철수', 'kim@example.com', 22, 'Computer Science', 3.85); -- 여러 데이터 일괄 추가 INSERT INTO students (name, email, age, major, gpa) VALUES ('이영희', 'lee@example.com', 21, 'Data Science', 3.92), ('박민준', 'park@example.com', 23, 'Computer Science', 3.45), ('정수진', 'jung@example.com', 22, 'AI Engineering', 3.78), ('최현주', 'choi@example.com', 20, 'Software Engineering', 3.55); -- 추가 확인 SELECT COUNT(*) AS total_students FROM students; 5 -- 전체 데이터 조회 SELECT * FROM students; -- 특정 컬럼만 조회 SELECT student_id, name, major, gpa FROM students; -- 조건부 조회 (GPA 3.7 이상) SELECT name, major, gpa FROM students WHERE gpa >= 3.7 ORDER BY gpa DESC; -- 전공별 평균 GPA SELECT major, AVG(gpa) AS avg_gpa, COUNT(*) AS student_count FROM students GROUP BY major ORDER BY avg_gpa DESC; -- 특정 학생 조회 SELECT * FROM students WHERE name = '김철수'; -- LIKE 조회 (이름에 '영' 포함) SELECT * FROM students WHERE name LIKE '%영%'; 6 -- 특정 학생의 GPA 업데이트 UPDATE students SET gpa = 3.95 WHERE name = '김철수'; -- 여러 컬럼 업데이트 UPDATE students SET age = 23, gpa = 3.88 WHERE student_id = 2; -- 조건부 대량 업데이트 UPDATE students SET gpa = gpa + 0.1 WHERE major = 'AI Engineering'; -- 변경 확인 SELECT * FROM students WHERE student_id = 1; 7 -- 특정 학생 삭제 DELETE FROM students WHERE student_id = 5; -- 조건부 삭제 (GPA 3.5 이하) DELETE FROM students WHERE gpa < 3.5; -- 전체 데이터 삭제 (주의!) -- DELETE FROM students; -- 삭제 후 확인 SELECT COUNT(*) AS remaining_students FROM students; 8 -- 테이블 구조까지 삭제 DROP TABLE IF EXISTS students; -- 데이터베이스 삭제 DROP DATABASE IF EXISTS test_db; 9 MySQL [test_db]> MySQL [test_db]> exit