MySQL Update activity when selecting user details

Question

Table:

userid, sessionid, last_active

I got the following requests:

SELECT `userid` FROM `session_keys` WHERE `sessionid`='SESSION_ID'

UPDATE `session_keys` SET `last_active`=now() WHERE `sessionid`='SESSION_ID'

Is it possible to put it in one request? but I need the callback from the select request.

The only goal i wanna reach is to update the last_active time of an timestamp when selecting the data.

Thank you.

I'm pretty sure you can, but I'm unclear what your exact request is. — user3783243, Jul 26 '18 at 23:30
You could put both statements inside a transaction so they're grouped and succeed or fail together. But generally SQL statements execute one at a time. What's the reason for wanting to group/combine the statements, out of curiosity? — RoboBear, Jul 26 '18 at 23:32
I wanna update the last active time automatically when selecting the data... — , Jul 27 '18 at 10:31

varTob · Answer 1 · 2018-07-27T01:22:08.373

0

try:

SET @session_id = 'SESSION_ID';
SELECT `userid` INTO @sid FROM `session_keys` WHERE `sessionid` = @session_id;
UPDATE `session_keys` SET `last_active`=now() WHERE `sessionid` = @session_id;
SELECT @sid;

Could you give more context?

edited Jul 27 '18 at 01:22

answered Jul 27 '18 at 01:01

varTob

124
6

The only goal i wanna reach is to update the last_active time of an timestamp when selecting the data. – Jul 27 '18 at 10:30
Do you want to do it by running the code from PHP or MySQL? – varTob Jul 27 '18 at 14:38
mysql prefered. – Jul 27 '18 at 22:40
did you try the queries? – varTob Jul 28 '18 at 06:22

score 0 · Answer 2 · edited Jul 27 '18 at 01:37

0

Try this query.

UPDATE
    'tableA' AS 'A',
    (
        SELECT
            *
        FROM
            'tableB'
        WHERE
            'id' = x
    ) AS 'src'
SET
    'A'.'col1' = 'src'.'col1'
WHERE
    'A'.'id' = x
;

edited Jul 27 '18 at 01:37

Pang

9,564
146
81
122

answered Jul 27 '18 at 01:08

Rajesh Om

483
2
15
39

I cannot understand what it does :o – Jul 27 '18 at 10:23

score 0 · Answer 3 · answered Jul 27 '18 at 10:47

0

Maybe this will be helpful:

Select and Update in same query (I know that you have the same table in both queries)

mysql select and update using one query in this case?

answered Jul 27 '18 at 10:47

nmr

358
4
10

MySQL Update activity when selecting user details

3 Answers3