컴퓨터언어/Database
[SQL] CRUD
bbanpro
2020. 5. 12. 20:14
728x90
반응형
CREATE TABLE student (
id INT NOT NULL,
name STRING,
address STRING,
PRIMARY KEY (id)
)
SELECT name
FROM students
WHERE address = "Seoul"
ALTER TABLE students
ADD scholarship MONEY
UPDATE students
SET scholarship = 3000000
where id = 2
DELETE FROM students
WHERE id = 1
728x90
반응형