Bit of a crap question, really, but is there a single command to find out the table type of an mySQL table?
I know I can do:
SHOW CREATE TABLE someTable;
and then suck the data off the end of the result, or you can do:
SHOW TABLE STATUS FROM databaseName LIKE "tablename";
and then check the Type column, but I'm in one of those "Oh, you can just shift click a link and it opens in a new window... really!" type stages where I miss every little time saving trick in the book.
Cheers me dears.
Originally posted by Drakla
... or you can do:
SHOW TABLE STATUS FROM databaseName LIKE "tablename";
As far as I'm aware, that is the shortcut.
Cheers man, I've just heaved one of those "If he's doing it that way too, that mean's I'm not an idiot." kind of sighs of relief. Wish I had more of them.
Reason I posted this is that I tried to create some InnoDB tables on a server (me2uweb.com hosting) where I'm hoping to do some work, and it creates them without a squeek, then of course they're actually MyIsam when I check.
Night all.
You know ... maybe they haven't enabled (or they turned off) InnoDB support - and MySQL just quietly used the default MyISAM instead of ragging on you. InnoDB and BDB are incredibly useful, but they might have turned suppport for them off because the way InnoDB stores the data allows you to get around imposed space limits ...