[SQL] CRUD

2020. 5. 12. 20:14컴퓨터언어/Database

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
반응형