storage engine

How do I know which storage engine a database uses?

show storage engines;

shows me all the possibillities, but I want to know it for one of my
created databases.

Thanks,

Achim

hakim wrote:

> How do I know which storage engine a database uses?
>
> show storage engines;
>
> shows me all the possibillities, but I want to know it for one of my
> created databases.
>
> Thanks,
>
> Achim

SHOW CREATE TABLE table_name

Captain Paralytic wrote:
> hakim wrote:
>
> > How do I know which storage engine a database uses?
> >
> > show storage engines;
> >
> > shows me all the possibillities, but I want to know it for one of my
> > created databases.
> >
> > Thanks,
> >
> > Achim
>
> SHOW CREATE TABLE table_name

or SHOW TABLE STATUS;