开发者

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

开发者 https://www.devze.com 2022-12-08 18:23 出处:网络
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.)

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

精彩评论

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