sql - Touch MYSQL record to update TIMESTAMP field -
in database have table column
`lastupdated` timestamp not null default current_timestamp on update current_timestamp,
i touch record in table lastupdated
column automatically updated don't want change value in row.
is possible?
thank you.
afaik, don't have options use touch
update mysql table records touch file in unix
systems. have issue update query update
timestamp
in lastupdated
column .
update mytable set lastupdated=now() ...
Comments
Post a Comment