Re: using the same field to be set in the update query and in the where clause

From: Peter H. Coffin <hellsop_at_ninehells.com>
Date: Thu, 9 Mar 2017 15:24:48 -0600
Message-ID: <slrnoc3i10.t3q.hellsop_at_nibelheim.ninehells.com>

On Thu, 9 Mar 2017 09:47:29 -0800 (PST), kushal bhattacharya wrote:

> hi yes i am keeping timestamp which changes on updation of therow

If you only want to update the timestamp, you do that by just updating the timestamp.

UPDATE `table` SET `updated_tmstp` = current_timestamp ;

-- 
"25 grams of wafers and 20 ml of wine undergo transubstantiation and
 become the flesh and blood of our Lord. How many Joules of heat are
 released by the transformation?"   --Theological Physics exam, 1997

Received on Thu Mar 09 2017 - 22:24:48 CET

This message: [ Message body ]
Next message: Peter H. Coffin: "Re: execute multiple queries with mysql c++ connector"
Previous message: kushal bhattacharya: "Re: execute multiple queries with mysql c++ connector"
Maybe in reply to: kushal bhattacharya: "using the same field to be set in the update query and in the where clause"
In reply to kushal bhattacharya: "Re: using the same field to be set in the update query and in the where clause"
Next in thread: Peter H. Coffin: "Re: execute multiple queries with mysql c++ connector"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message