SammyJoyce Comments - Answer Overflow

SammyJoyce

•Created by Jonathan on 8/1/2023 in #help

Drizzle kit SQL error

Updated. The ‘null’ is the default when created, and but it retains the ON UPDATE at the end of the sql query, so updates, on update

12 replies

•Created by Jonathan on 8/1/2023 in #help

Drizzle kit SQL error

 updatedAt: datetime("updated_at", { mode: "date", fsp: 3 }).default(
    sql.raw(`NULL ON UPDATE CURRENT_TIMESTAMP(3)`),
  ),

 updatedAt: datetime("updated_at", { mode: "date", fsp: 3 }).default(
    sql.raw(`NULL ON UPDATE CURRENT_TIMESTAMP(3)`),
  ),

This seems to be working

12 replies

•Created by Jonathan on 8/1/2023 in #help

Drizzle kit SQL error

https://github.com/drizzle-team/drizzle-orm/issues/472 I have the same issue. Can't find a fix for onUpdateNow()

12 replies