From: Reindl Harald
Date: October 4 2012 3:31pm
Subject: Re: user last activity and log in
List-Archive: http://lists.mysql.com/mysql/228322
Message-Id: <506DABEE.4030400@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig2FAB4EB078BE3ED41AC5B11A"

--------------enig2FAB4EB078BE3ED41AC5B11A
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 04.10.2012 17:28, schrieb Aastha:
> I want to find the last time the given list of users logged in.
> Is there any mysql table from where i can retrieve the data or any
> specific sql

no - because this would mean a WRITE QUERY in the mysql-database
for every connection - having a web-application with hundrets
of calls per second would kill the performance

this makes pretty no sense and is NOT the job of a RDBMS
implement it in your application / db-abstraction-layer


--------------enig2FAB4EB078BE3ED41AC5B11A
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlBtq+4ACgkQhmBjz394AnlH9QCeOY2LUKhrM3uzceCTnPLJ3+ue
nhEAmwcEHN7qNothiX66huVp0Hf75tC2
=IVQl
-----END PGP SIGNATURE-----

--------------enig2FAB4EB078BE3ED41AC5B11A--