Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

How to Force UPDATE of MySQL Record When Nothing Is Changing

Tags:

mysql

onupdate

My database table has a column defined to use ON UPDATE CURRENT_TIMESTAMP:

Field: last_access
Type: timestamp
Collation:
Attributes: on update CURRENT_TIMESTAMP
Null: No
Default: CURRENT_TIMESTAMP
Extra: ON UPDATE CURRENT_TIMESTAMP

How can I force this last_access field to update for a given record when no other data in the record is changing?

like image

569

asked Feb 09 '12 21:02

Jim Fell

1 Answers

UPDATE your_table SET last_access = CURRENT_TIMESTAMP(); ?

like image

70

answered Oct 08 '22 15:10

berty

Sign in to Comment

Related questions
                            
                                MySQL order by two columns and order results again
                            
                                How to build a paypal donation system that gives points
                            
                                Iterating without using cursor in MYSQL
                            
                                Anyway to Limit MySQL Query Execution time?
                            
                                Hibernate exception on open sessions. How can I debug this?
                            
                                What are the advantages of using DBIx::Connector over simply setting mysql_auto_reconnect to 1?
                            
                                Is there a Performance impact if stored varchar data is less than the defined size limit?
                            
                                MySQL administration tool with serious foreign key management [closed]
                            
                                Which is more efficient: One long Single Table or Distributed Table? and Why?
                            
                                Why is the my.cnf file on the server incomplete or has very few entries?
                            
                                Can't insert foreign key value into linking table
                            
                                How to UPDATE just one record in DB2?
                            
                                MySQL using IN/FIND_IN_SET to read multiple rows in sub query
                            
                                MYSQL - Sort 2 Columns Alphabetically, using second column if first column is null
                            
                                How to change the phpmyadmin database encoding
                            
                                If I receive post data with Flask, put that data into a WTForms form and it successfully validates, is it safe from SQL injection attacks?
                            
                                Get invoking user ID (only) from MySQL
                            
                                Echoing the sum of a table in PHP
                            
                                Number of affected rows Zend DB (UPDATE)
                            
                                How can I summarize rows that occur only once?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With