0
private 도메인 확인 > db-4a8det.vpc-cdb.ntruss.com



yum install mysql

mysql -u student -h db-4a8det.vpc-cdb.ntruss.com -p




mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| basicdb1           |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)





1
USE basicdb1;


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



2
# 입력

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;