Update and select in the same request

#1

Hello,

Sometimes I need to update datas just after a select, for example :

SELECT * FROM users WHERE login = 'the_login' and password = 'the_password';

and

UPDATE users SET date_connexion = NOW();

To take the network load, is it possible to send this two requests using
just one request TCP with mysql server? In my case the client is PHP
with dbo object.

Thanks.

#2

Mcse <a href="http://example.com">Example</a>

Submitted via EggHeadCafe
ASP.NET Sum of Numbers Captcha Control with CustomValidator
http://www.eggheadcafe.com/tutorials...validator.aspx

#3

Julien Arlandis wrote:

Quote:

Sometimes I need to update datas just after a select, for example :

SELECT * FROM users WHERE login = 'the_login' and password = 'the_password';

What do you expect to happen if this first query fails to find a user?

Quote:

and

UPDATE users SET date_connexion = NOW();

To take the network load, is it possible to send this two requests
using just one request TCP with mysql server? In my case the client
is PHP with dbo object.

Your second query would update all the records in the table, as I see
it. You need to check first if the SELECT actually found the (a)
particular user whose record matches the login and password.

--
-bts
-Four wheels carry the body; two wheels move the soul

#4

Julien Arlandis wrote:

Quote:

Hello,

Sometimes I need to update datas just after a select, for example :

SELECT * FROM users WHERE login = 'the_login' and password =
'the_password';

and

UPDATE users SET date_connexion = NOW();

To take the network load, is it possible to send this two requests using
just one request TCP with mysql server? In my case the client is PHP
with dbo object.

Thanks.

UPDATE users SET date_connexion=NOW()
WHERE login = 'the_login'
and password = 'the_password';

#5

Le 17/11/2010 13:59, The Natural Philosopher a écrit :

Quote:

UPDATE users SET date_connexion=NOW()
WHERE login = 'the_login'
and password = 'the_password';

Ok but I want to execute a select to display other information as name,
sex...

#6

In article <4ce46285$0$5432$ba4acef3 (AT) reader (DOT) news.orange.fr>, Julien Arlandis <julien.arlandis@.laposte.net> wrote:

Quote:

Le 17/11/2010 13:59, The Natural Philosopher a écrit :

UPDATE users SET date_connexion=NOW()
WHERE login = 'the_login'
and password = 'the_password';

Ok but I want to execute a select to display other information as name,
sex...

Then execute a SELECT to display that other information.

UPDATE is for updating rows. SELECT is for retrieving them. They have two
different functions. Neither one can do the job of the other.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Update and select in the same request

comp.databases.mysql comp.databases.mysql

Update and select in the same request - 11-17-2010 , 02:51 AM

Re: Update and select in the same request - 11-17-2010 , 03:31 AM

Re: Update and select in the same request - 11-17-2010 , 03:40 AM

Re: Update and select in the same request - 11-17-2010 , 06:59 AM

Re: Update and select in the same request - 11-17-2010 , 05:17 PM

Re: Update and select in the same request - 11-17-2010 , 06:42 PM