CODEWITHSUNDEEP
mysqlmysql-workbench
Spartacus
Spartacus

Reputation: 442

Check the version of database when a table was created in MySQL

Is there a way to check the version of the database when a table was created?

Thanks in advance.

Upvotes: 0

Views: 541

Answers (1)

Bill Karwin
Bill Karwin

Reputation: 562911

Not really. MySQL does not track the version of software when the table was created.

The metadata for a table can be viewed with the command SHOW TABLE STATUS. One of the fields is labeled VERSION, but it's not the version of MySQL Server, it's the version of the ".frm" file format, which was a file to store metadata about the table. It was version 10 in MySQL 5.7, but in MySQL 8.0 they no longer use .frm files, so the value will be fixed at "10" forever.

Out of curiosity, why do you need to know this?

Upvotes: 1

Related Questions