knex how to auto update column value?

Question

mysql

`modify_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'modify datetime'

javascript

knex.schema.createTable(`record_${today}`,
    function (table) {
        table
            .datetime("modify_at")
            .comment("modify date")
            .notNullable()
            .onUpdate(knex.fn.now());
    }
);

the code run error. it say onUpdate is not a function

[this answer](https://stackoverflow.com/a/46106302/122643) gives a MySQL approach (using `.raw`). — Rich Churcher, Mar 24 '21 at 06:40

score 0 · Accepted Answer · answered Mar 24 '21 at 05:35

0

For this porpoise, you can use timestamps method http://knexjs.org/#Schema-timestamps

answered Mar 24 '21 at 05:35

Denis Malykhin

349
1
6

Unfortunately, this will not achieve the result suggested by the SQL in the question (it only sets the timestamp values once, not on each update). – Rich Churcher Mar 24 '21 at 06:39
This is wrong answer. Rich Churcher gave link to correct in his other comment. – Mikael Lepistö Jul 28 '21 at 21:22

knex how to auto update column value?

1 Answers1