article thumbnail image
Published 2022. 10. 4. 21:36

예시

CREATE TABLE zoo (
  name TEXT NOT NULL,
  eat TEXT NOT NULL,
  weight INT NOT NULL,
  height INT,
  age INT
);

INSERT INTO zoo (name, eat, weight, height)
VALUES
  ('rabbit', 'herbivore', 3, 150),
  ('eagle', 'carnivore', 8, 75),
  ('alligator', 'carnivore', 250, 50);


-- 토끼의 키를 15로 수정
UPDATE zoo
SET height = 15
WHERE name = 'rabbit';
복사했습니다!