开发者

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

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`
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜