Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 66 to server version: 5.0.16-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use `test`;
Database changed
mysql> CREATE TABLE `time` (
-> `id` INT(4) NOT NULL AUTO_INCREMENT,
-> `create_timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-> `datetime` DATETIME NOT NULL,
-> `some_data` INT(4) NOT NULL,
-> PRIMARY KEY (`id`)
-> ) ENGINE = MYISAM;
Query OK, 0 rows affected (0,04 sec)
mysql> INSERT INTO `time` SET `some_data` = 10; -- автоматическая установка `create_timestamp`
Query OK, 1 row affected, 1 warning (0,00 sec)
mysql> SELECT * FROM `time`;
+----+---------------------+---------------------+-----------+
| id | create_timestamp | datetime | some_data |
+----+---------------------+---------------------+-----------+
| 1 | 2006-10-17 13:50:14 | 0000-00-00 00:00:00 | 10 |
+----+---------------------+---------------------+-----------+
1 row in set (0,01 sec)
mysql> UPDATE `time` SET `datetime` = NOW(); -- `create_timestamp` не изменяется
Query OK, 1 row affected (0,00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> SELECT * FROM `time`;
+----+---------------------+---------------------+-----------+
| id | create_timestamp | datetime | some_data |
+----+---------------------+---------------------+-----------+
| 1 | 2006-10-17 13:50:14 | 2006-10-17 13:50:44 | 10 |
+----+---------------------+---------------------+-----------+
1 row in set (0,00 sec)
mysql> SHOW VARIABLES like 'time_zone'; -- все это дело происходит в системном часовом поясе
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| time_zone | SYSTEM |
+---------------+--------+
1 row in set (0,00 sec)
mysql> SHOW VARIABLES like 'system_time_zone'; -- т.е. Москва
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| system_time_zone | MSD |
+------------------+-------+
1 row in set (0,00 sec)
mysql> SET time_zone = 'Europe/Samara'; -- сменим часовой пояс на Самару
Query OK, 0 rows affected (0,00 sec)
mysql> SELECT * FROM `time`;
+----+---------------------+---------------------+-----------+
| id | create_timestamp | datetime | some_data |
+----+---------------------+---------------------+-----------+
| 1 | 2006-10-17 14:50:14 | 2006-10-17 13:50:44 | 10 |
+----+---------------------+---------------------+-----------+
1 row in set (0,00 sec)
