Henrik Ingo <henrik.ingo@avoinelama.fi> writes:
Where else would @@TIMESTAMP be modified? Can a user do that from SQL?
Yes (or @TIMESTAMP at least).. mysql> set TIMESTAMP=100; Query OK, 0 rows affected (0.00 sec) mysql> select now(); +---------------------+ | now() | +---------------------+ | 1970-01-01 01:01:40 | +---------------------+ 1 row in set (0.00 sec) mysql> show full processlist; +----+------+-----------+------+---------+------------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+------+---------+------------+-------+-----------------------+ | 15 | root | localhost | test | Query | 1253605187 | NULL | show full processlist | +----+------+-----------+------+---------+------------+-------+-----------------------+ 1 row in set (0.00 sec)
(If so, why???)
Loading mysqlbinlog output, testing, ... and confusing SHOW FULL PROCESSLIST :-) Thanks, - Kristian.