본 글은 Udemy의 '데이터 역량 강화를 위한 SQL 부트캠프' 강의를 듣고 정리한 글입니다.
본 글은 강의를 수강한 입장에서 복습을 더 쉽게 하기 위한 글입니다.
CREATE TABLE tbl(
col1 TYPE col_contraint,
col2 TYPE col_contraint);
CREATE TABLE players(
player_id SERIAL PRIMARY KEY,
age SMALLINT NOT NULL);
INSERT INTO tbl_name(col_1, col_2, time)
VALUES
('one', 'two', CURRENT_TIMESTAMP)
UPDATE tbl_name
SET col_1 = val_1
col_2 = val_2
WHERE condition;
UPDATE account_job
SET hire_date = accuount.created_on
FROM account
WHERE account_job.user_id = account.user_id
DELETE FROM tbl_1
WHERE id=1
DELETE FROM tbl_1
USING tbl_2
WHERE tbl_1.id = tbl_2.id
DELETE FROM tbl_1 # 다 지우기
ALTER TABLE tbl_name
ALTER COLUMN col_name DROP/SET contraint(e.g. NOT NULL, UNIQUE)
ALTER TABLE tbl_name
DROP COLUMN IF EXISTS col_name
CREATE TABLE tbl_1(
id SERIAL PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
birth_date DATE CHECK (birth_date > '1900-01-01'),
hire_date DATE CHECK (hire_date > birth_date),
salary INTEGER CHECK (salary > 0)