List:General Discussion« Previous MessageNext Message »
From:william drescher Date:February 12 2013 12:33pm
Subject:select and update in the same statement
View as plain text  
I am finding I need to retrieve data from a row and also update 
the 'lastAccess' field in that row.  I am using PHP and now do it 
in two calls to MySQL.
Can one of the wizards suggest a way that I can do both in one call ?

Not a big deal, just interesting.


select and update in the same statementwilliam drescher12 Feb