Pada Sun, 7 Jul 2002 13:04:02 -0400
"sajiddalvi" <[EMAIL PROTECTED]> menulis :
> Is there a way to check which my sql user (who has logged into the database)
> has inserted a row in a table?
> I could add a "logged_in_user" column but that seems redundant.
you can set your mysqld to log all activities (from my.cnf or command-line when
starting mysqld), and track it from the log files.
but mysql doesn't have like "last" as UNIXes do.
for active users, you can see from "show processlist"
--
Sic transit discus mundi
-- From the System Administrator's Guide, by Lars Wirzenius
MySQL 3.23.51 : up 16 days, Queries : 367.960 per second (avg).
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
