Very helpful. I will look into the coverting the addresses.
On 9/28/05, Patrick <patrick@stripped> wrote:
> Historically any form of punctuation, parameter delimiter, or filepath
> delimiter in either a database name, field or column name, file or table
> name would not be recommended; even if the RDBMS or File Handler allows
> If you are able to stick to alphanumeric characters using underscores
> characters if needed for clarity, you go a long way for portability across
> various operating systems. Also, IPv4 addresses are readily converted to
> single 32bit integers that minimize the need for dotted quartets.
> Early versions of MySQL allowed periods. This caused OS incompatibility
> issues. To my knowledge this was fixed prior to version 3 and you are no
> longer allowed periods in database or table names. This, in my thinking,
> a good thing by assuring greater portability and easier migration.
> I hope this helps.
> CocoNet Corporation
> SW Florida's First ISP
> 825 SE 47th Terrace
> Cape Coral, FL 33904
> ----- Original Message -----
> From: "Chance Ellis" <chance.ellis@stripped>
> To: <mysql@stripped>
> Sent: Wednesday, September 28, 2005 12:57 PM
> Subject: Re: Table names with periods
> Instead of criticizing people's designs without understanding the
> requirements why don't you just answer the question, or don't you know
> On 9/28/05, Martijn Tonies <m.tonies@stripped> wrote:
> > >
> > >I am sure this has been asked before but I can't seemed to find it.
> > > Canyou create table names with periods in them? I need to create
> > >based on the IP address of machines (x.x.x.x)
> > Ehm. Why?
> > Instead of going the "silly table names" route, why not try a different
> > design?
> > With regards,
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
> > Server
> > Upscene Productions
> > http://www.upscene.com
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1