0

yum install mysql

mysql -u student -h db-49cs89.vpc-cdb.ntruss.com -p



show databases;



USE `bts-box`;



CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    age INT,
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);




# 입력

INSERT INTO users (name, age, email) VALUES
('홍길동', 30, 'hong@example.com'),
('김철수', 25, 'kim@example.com'),
('이영희', 28, 'lee@example.com');



3

SELECT * FROM users;


4

SELECT * FROM users WHERE age >= 28;


5

UPDATE users
SET age = 31
WHERE id = 1;


6

DELETE FROM users
WHERE id = 3;


7

SELECT * FROM users;