앨리스래빗팀 기술블로그

에러메세지 Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 해결방법 Safe 모드 비활성화 set sql_safe_updates=0; 작업후 다시 Safe 모드를 활성화 시켜놓을 것 set sql_safe_updates=1;

CREATE TABLE IF NOT EXISTS [새로운테이블명] LIKE [복사할테이블명];

SELECT NOW(); SHOW GLOBAL VARIABLES LIKE '%zone%';

.lean() 사용

PK - Primary Key NN - Not Null BIN - Binary (stores data as binary strings. There is no character set so sorting and comparison is based on the numeric values of the bytes in the values.) UN - Unsigned (non-negative numbers only. so if the range is -500 to 500, instead its 0 - 1000, the range is the same but it starts at 0) UQ - Create/remove Unique Key ZF - Zero-Filled (if the length is 5 like ..

.populate({path:'study', match: {owner: req.user.id}}) populate 조건에 match 사용해서 조건을 건다.

result.markModified('tags'); When Nested Object Changed 자식 요소는 마킹을 해주어야 감지됨