CODEWITHSUNDEEP
mysqlinnodb
titel
titel

Reputation: 3502

InnoDB CURRENT_TIMESTAMP update without updating row data

Is there a simple way of triggering the update of a "ON UPDATE CURRENT_TIMESTAMP" column without actually updating data in the row?

Upvotes: 0

Views: 67

Answers (1)

Barmar
Barmar

Reputation: 781804

You can simply update the timestamp directly:

UPDATE yourTable SET timestamp_column = NOW()

Upvotes: 1

Related Questions