Server/node.js
nodejs mysql2 error
void
2020. 3. 31. 10:00
(node:47343) UnhandledPromiseRejectionWarning: Error: Unknown column 'board.level' in 'field list'
board테이블에 level 컬럼이 있음에도 위와 같은 에러가 발생하였다.
SELECT board.lv FROM BOARD as board LEFT JOIN MEMBER as user ON board.idx=user.idx;위의 sql문을 아래의 sql문으로 변경해주니 해결됨
SELECT 'board.lv' FROM BOARD as board LEFT JOIN MEMBER as user ON board.idx=user.idx;