从元数据中检索MySQL行创建的时间戳?

问题描述:

我一直在维护一个MySQL表,该表包含从PHP代码插入的数据行,大约有一年半的时间.我知道这真是愚蠢,我没有包含用于插入这些行的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有一个秘密的timestamp字段,则表的一般大小将增加每行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.