Henrik Ingo <henrik.i...@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.
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
