Error in executing the query: You have an error in your SQL syntax; '@gmail.com'

j_wisdom_h·2023년 12월 12일
0

Error

목록 보기
7/8
Error in executing the query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com LIMIT 1' at line 1
 ⨯ Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com LIMIT 1' at line 1
...
{
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlState: '42000',
  sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com LIMIT 1' at line 1",
  sql: 'select email, password from bridge.user where email = bridge@gmail.com LIMIT 1'
}

const sql = select email, password from bridge.user where email = ${body.username}

const sql = select email, password from bridge.user where email = '${body.username}'
로 수정

profile
뚜잇뚜잇 FE개발자

0개의 댓글