how to recongnize which storage engine used for database.

Hi all,

I am newbie to mysql, i know all standard location where we can get database. I wanted to know which storage engine (myisam, innodb, etc) is used to store data.

use:

Code:

---

SHOW TABLE STATUS

---

table engine will be in column 'Engine' ;)

Isnt there anything which will result database details. I mean when its created, type, storage engine, size etc......

Code:

---

SHOW TABLE STATUS

---

Shows what do you need - tables creation date, engine, last update date and so on. It shows info about all tables in database that is using (command USE)