본문 바로가기
MySQL/생활코딩

생활코딩 - MySQL - 12. UPDATE

by SKim입니다 2020. 6. 8.

 

검색어: MySQL update

 

https://dev.mysql.com/doc/refman/8.0/en/update.html

 

MySQL :: MySQL 8.0 Reference Manual :: 13.2.13 UPDATE Statement

MySQL 8.0 Reference Manual  /  ...  /  SQL Statements  /  Data Manipulation Statements  /  UPDATE Statement 13.2.13 UPDATE Statement UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to defin

dev.mysql.com

assignment: 컬럼 이름의 값이라는 세트

 

 

UPDATE topic SET description='MongoDB is ...', title='MongoDB' WHERE id=2;

 

WHERE문을 빼먹으면 대재앙이 온다.

댓글