MySQL Lists: mysql: select and update in the same statement

List:	General Discussion	« Previous Message Next 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.

bill

Thread
• select and update in the same statement	william drescher	12 Feb 2013