From: Martijn Tonies
Date: September 28 2005 7:39pm
Subject: Re: Table names with periods
List-Archive: http://lists.mysql.com/mysql/189728
Message-Id: <009101c5c464$5ee7f240$c802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>Point taken and yes the manual was reviewed. However, I thought in the past
>that I had seen someone post a method in which table names could be created
>with special characters.

Most special characters can be used by using "back ticks":

`my_special name - for example with dashes and spaces`

That being said, one should/could stick to "normal" names to avoid any
issues :-)

Anyway, care to enlighten us on the requirements?

Cause I want to raise the point that any database design that requires you
to add a table in order to add data for a certain new "node" or anything,
is faulty... :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com