<p>회원 가입부분을 한번 해보고 싶은데 id 부분이랑 createdAt,updatedAt 설정을 어떻게 해야할지 문의 드립니다.&nbsp;</p>
<div style="color: #abb2bf; background-color: #282c34; font-family: Menlo, Monaco, 'Courier New', monospace; font-size: 12px; line-height: 18px; white-space: pre;">
<div><span style="color: #c678dd;">await</span> <span style="color: #e5c07b;">sequelize</span>.<span style="color: #61afef;">query</span>(<span style="color: #98c379;">`</span></div>
<div><span style="color: #98c379;"> INSERT INTO users </span></div>
<div><span style="color: #98c379;"> (id,</span></div>
<div><span style="color: #98c379;"> userName,</span></div>
<div><span style="color: #98c379;"> email,</span></div>
<div><span style="color: #98c379;"> password,</span></div>
<div><span style="color: #98c379;"> phoneNumber,</span></div>
<div><span style="color: #98c379;"> memberClassification,</span></div>
<div><span style="color: #98c379;"> membershipGrade,</span></div>
<div><span style="color: #98c379;"> memberRole,</span></div>
<div><span style="color: #98c379;"> createdAt,</span></div>
<div><span style="color: #98c379;"> updateAt) </span></div>
<div><span style="color: #98c379;"> values (?,?,?,?,?,?,?)</span></div>
<div><span style="color: #98c379;"> `</span>,</div>
<div>{</div>
<div><span style="color: #e06c75;">replacements</span>: [</div>
<div><span style="color: #e06c75;">id부분</span> <span style="color: #e06c75;">어떻게</span> <span style="color: #e06c75;">써야하나요</span><span style="color: #c678dd;">?</span></div>
<div><span style="color: #e06c75; font-style: italic;">req</span>.<span style="color: #e06c75;">body</span>.<span style="color: #e06c75;">userName</span>,</div>
<div><span style="color: #e06c75; font-style: italic;">req</span>.<span style="color: #e06c75;">body</span>.<span style="color: #e06c75;">email</span>,</div>
<div><span style="color: #e06c75; font-style: italic;">req</span>.<span style="color: #e06c75;">body</span>.<span style="color: #e06c75;">password</span>,</div>
<div><span style="color: #98c379;">"0"</span>,</div>
<div><span style="color: #e06c75; font-style: italic;">req</span>.<span style="color: #e06c75;">body</span>.<span style="color: #e06c75;">memberClass</span>,</div>
<div><span style="color: #98c379;">"0"</span>,</div>
<div><span style="color: #98c379;">"0"</span>,</div>
<div><span style="color: #e06c75;">createdAt</span> <span style="color: #e06c75;">부분을</span> <span style="color: #61afef;">now</span>()<span style="color: #e06c75;">로</span> <span style="color: #e06c75;">하고</span> <span style="color: #e06c75;">싶은데</span> <span style="color: #e06c75;">어떻게</span> <span style="color: #e06c75;">써야하나요</span><span style="color: #c678dd;">?</span></div>
<div><span style="color: #e06c75;">updateAt</span> <span style="color: #e06c75;">부분을</span> <span style="color: #61afef;">now</span>()<span style="color: #e06c75;">로</span> <span style="color: #e06c75;">하고</span> <span style="color: #e06c75;">싶은데</span> <span style="color: #e06c75;">어떻게</span> <span style="color: #e06c75;">써야하나요</span><span style="color: #c678dd;">?</span></div>
<div>],</div>
<div><span style="color: #e06c75;">type</span><span style="color: #c678dd;">:</span> <span style="color: #e5c07b;">QueryTypes</span>.<span style="color: #56b6c2;">INSERT</span>,</div>
<div>}</div>
<div>);</div>
</div>

<p>id랑 createdAt, updatedAt은 기본값 설정이 되어있어서 아예 빼고 등록하셔도 됩니다. 날짜는 Date.now() 하셔도 되고요.</p>

[리뉴얼] React로 NodeBird SNS 만들기

raw query 한번 해보고 싶은데 궁금한점이 있습니다!

회원가입 구현하기

데이터베이스 관리 시스템입니다.

프론트엔드 렌더링 도구입니다.

인프런 커뮤니티 질문&답변

raw query 한번 해보고 싶은데 궁금한점이 있습니다!