The SWOW CREATE TABLE query doesn't seem to give any result if the table has no rows. (At least not in my php setup.) Is there an eas开发者_运维百科y way to get around that without delving into the meta tables? If so, how? :-)
EDIT:
As my comment on Quassnoi's answer below indicates, this seems to be a problem for tables named starting "x-"... Very strange!
SHOW CREATE TABLE
works even if there are no rows.
Could you please reproduce this with a command line client or phpMyAdmin
?
Update:
-
is a reserved character. You need to enclose the names like this into backticks:
SHOW CREATE TABLE `x-addresses`
精彩评论