Re: Table names with periods

2005-10-04 Thread Chance Ellis
AIL PROTECTED]> wrote: > > Chance Ellis wrote: > [snip] > > of CREATE TABLE entries. I then import those files with a cron script > into > > mysql. This is where I am looking to convert IP address into something > [snip] > > There is a world of possibilit

Re: Table names with periods

2005-10-03 Thread Chance Ellis
ic SQL and I am not 100% sure it would > accept what you typed. > > > > > You would obviously add your "CREATE TABLE" options and "INTO > > OUTFILE" options as needed. > > This would be an alternative to converting IPv4 to 32bit Integer. > > >

Re: Table names with periods

2005-09-28 Thread Chance Ellis
names. This, in my thinking, > is > a good thing by assuring greater portability and easier migration. > > I hope this helps. > > Pat... > > [EMAIL PROTECTED] > CocoNet Corporation > SW Florida's First ISP > 825 SE 47th Terrace > Cape Coral, FL 33904 &g

Re: Table names with periods

2005-09-28 Thread Chance Ellis
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. On 9/28/05, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > > > > > >Instead of criticizing people's designs without un

Re: Table names with periods

2005-09-28 Thread Chance Ellis
Instead of criticizing people's designs without understanding the requirements why don't you just answer the question, or don't you know either? On 9/28/05, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > > >I am sure this has been asked before but I can't seemed to find it. > > Canyou create ta

Table names with periods

2005-09-28 Thread Chance Ellis
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 tables based on the IP address of machines (x.x.x.x) Currently, Mysql is puking on format. Any ideas? Thanks