Languages

MySQL - how to check existing table engine?

0 points
Asked by:
Dirask Community
6930

How can I check an existing table engine? I created the table some time ago and I don't remember which engine I specified when creating it.

1 answer
0 points
Answered by:
Dirask Community
6930

Use the following query:

SHOW TABLE STATUS WHERE Name = 'table_name';

Note:

Change only the table_name.

0 comments Add comment
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join