K
K
Konstantin Malyarov2017-02-09 16:20:21
MySQL
Konstantin Malyarov, 2017-02-09 16:20:21

How to update only one TIMESTAMP column?

There are two columns with TIMESHTAMP, how to update only one?
current_timestamp and now() update both

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Peter, 2017-02-09
@Konstantin18ko

The TIMESTAMP column type provides a data representation type that can be used to automatically capture the current date and time when performing an INSERT or UPDATE operation. If there are multiple TIMESTAMP columns, only the first one is updated automatically.

Here

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question