MySql: "SHOW CREATE TABLE" doesn't work for tables named "x-..."?

Question

Hi!

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 easy 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!

Answer 1

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`