DATE_FORMAT en Update_time de SHOW TABLE STATUS

[huesos52]

En cuanto a bases de datos no se que tan fiable sea tu consulta.

Código mysql:

mysql> select *from repetidos1;
+------+--------+
| id   | nombre |
+------+--------+
|    1 | daniel |
|    2 | sara   |
+------+--------+
2 rows in set (0.01 sec)
 
mysql> update repetidos1 set nombre='sara bastos' where id=2;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
mysql> show table status from sgh like 'repetidos1';
+------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----
--------------+----------+----------------+----------------------+
| Name       | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Coll
ation         | Checksum | Create_options | Comment              |
+------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----
--------------+----------+----------------+----------------------+
| repetidos1 | InnoDB |      10 | Compact    |    2 |           8192 |       16384 |               0 |            0 |         0 |           NULL | 2009-11-10 09:06:37 | NULL        | NULL       | lati
n1_swedish_ci |     NULL |                | InnoDB free: 4096 kB |
+------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----
--------------+----------+----------------+----------------------+
1 row in set (0.01 sec)
 
mysql>
 

Depués de actualizar y revisar la tabla, el campo update_time me sigue apareciendo como null.