restriction for table names?

[jshuen]

Hi,

was just wondering whether there is a restriction on the amount of characters that are allowed for table names?

thanks,

jshuen

 

[sleipnir214]

Yes.

http://www.mysql.com/doc/en/Legal_names.html

Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[jshuen]

thankyou

 

[jshuen]

sorry, another question, does it impact the performance if the table names are longer, rather than shorter?

 

[sleipnir214]

MySQL stores a database as a directory, and a table in that database as a file in that directory. If you are running MySQL on Win32, and have MySQL's databases on a FAT32 partition, and if you are using table names longer than 8 characters, the filesystem would have to do that weird multiple-directory-entry thing it does to store the long filenames. It might be within the realm of possibility that this could affect performance, but I sincerely doubt it. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!