mysql> CREATE TABLE daten_time (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, data VARCHAR(64), ts TIMESTAMP); mysql> CREATE TABLE daten_random (id CHAR(32) NOT NULL PRIMARY KEY, data VARCHAR(64), ts TIMESTAMP); mysql> INSERT INTO daten_time VALUES ( NULL, 'Zeile 1', NULL); SELECT SLEEP(1); mysql> INSERT INTO daten_time VALUES ( NULL, 'Zeile 2', NULL); SELECT SLEEP(1); mysql> INSERT INTO daten_time VALUES ( NULL, 'Zeile 3', NULL); SELECT SLEEP(1); mysql> INSERT INTO daten_random VALUES ( MD5(CURRENT_TIMESTAMP()), 'Zeile 1', NULL); SELECT SLEEP(1); mysql> INSERT INTO daten_random VALUES ( MD5(CURRENT_TIMESTAMP()), 'Zeile 2', NULL); SELECT SLEEP(1); mysql> INSERT INTO daten_random VALUES ( MD5(CURRENT_TIMESTAMP()), 'Zeile 3', NULL); SELECT SLEEP(1); mysql> CREATE TABLE `daten_time` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `data` VARCHAR(64) DEFAULT NULL, `ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 mysql> CREATE TABLE `daten_random` ( `id` CHAR(32) NOT NULL, `data` VARCHAR(64) DEFAULT NULL, `ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT mysql> SELECT * FROM daten_time; +----+---------+---------------------+ | id | data | ts | +----+---------+---------------------+ | 1 | Zeile 1 | 2015-09-13 15:24:05 | | 2 | Zeile 2 | 2015-09-13 15:24:06 | | 3 | Zeile 3 | 2015-09-13 15:24:07 | +----+---------+---------------------+ mysql> SELECT * FROM daten_random; +----------------------------------+---------+---------------------+ | id | data | ts | +----------------------------------+---------+---------------------+ | 47e0142a3638fdc24fe40d4e4fbce3f1 | Zeile 1 | 2015-09-13 15:24:12 | | b833c1e4c5bfc47d0dbe31c2e3f30837 | Zeile 3 | 2015-09-13 15:24:14 | | c7d46523a316de4e1496c65c3cbdf358 | Zeile 2 | 2015-09-13 15:24:13 | +----------------------------------+---------+---------------------+