从元数据中检索 MySQL 行创建的时间戳?
我一直在维护从 PHP 代码插入的数据行的 MySQL 表大约一年半.真的很愚蠢，我知道，我没有包含用于插入这些行的 timestamp.
I have been maintaining a MySQL table of rows of data inserted from PHP code for about a year and a half. Really stupid, I know, I didn't include the timestamp for insertion of these rows.
是否有任何可能的方法可以通过某些元数据或其他方式检索创建这些行的 timestamp ?(MySQL 或 PHPMyAdmin 或其他一些可能的方式?)
Is there any possible way that I can retrieve the timestamp of creation of these rows through some metadata or some other way? (Of MySQL or PHPMyAdmin or some other possible ways?)
推荐答案
很遗憾，在这种情况下您无能为力.如果 MySQL 有一个秘密时间戳字段，表的一般大小 将会增加每行 4 个字节.
Unfortunately, there's nothing you can do in this case. If MySQL had a secret timestamp field, the general size of tables would increase by 4 bytes per row.
相关文章