[SQL] CRUD

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

2020.05.12