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`
加载中,请稍侯......
精彩评论