Clever Geek Handbook

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

The SWOW CREATE TABLE query doesn't seem to give a result if there are no rows in the table. (At least not in my php setup.) Is there an easy way to get around this without going into meta tables? If so, how? :-)

EDIT:

As my comment on Quassnoi below shows, this seems like a problem for tables named "x -" ... Very strange!

+2


source to share


1 answer


SHOW CREATE TABLE

works even if there are no lines.

Could you please reproduce this using the command line or phpMyAdmin

?

Update:



-

is a reserved character. You need to attach names like this to the backlinks:

SHOW CREATE TABLE `x-addresses`
+1


source






More articles:


All Articles