Thanks everyone for all of the replies! I have been banging my head against
this for a week now and I was never looking in the direction of the cron
script... Sometimes it helps having another set (or ten) of eyes looking at
the problem.
Thanks again!
On 10/3/05, Bastian Balthazar Bux <[EMAIL P
ad, that he wasn't looking for
help in db design, just a solution to the punctuation issue.
Pat...
- Original Message -
From: [EMAIL PROTECTED]
To: Patrick
Cc: Chance Ellis ; mysql@lists.mysql.com
Sent: Monday, October 03, 2005 4:30 PM
Subject: Re: Table names with periods
Repl
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 possibilities at this point, one is this:
sed \
--expression='s/@@@NEEDTOREPLACETHIS\([012345
'), " [insert
> > > create options here]" FROM IP_Addresses WHERE status ="ACTIVE"
> >
> > Dynamic SQL? Not with that statement. He is going to need to create his
> > SQL statement client-side and send it pre-formatted to the server. MySQL
>
Chance Ellis wrote:
[snip]
Thus, syslog-ng creates a file that contains a bunch 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
without periods. I cannot perform logic within the .conf file and it
a
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.
> >
>
this helps...
>
> If at all possible, it is probably best to continue in the MySQL
> list, there are some pretty clever people out there
>
> Pat...
>
> [EMAIL PROTECTED]
> CocoNet Corporation
> SW Florida's First ISP
> 825 SE 47th Terrace
> Cape Coral, FL 3390
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: Chance Ellis
To: Patrick
Sent: Monday, October 03, 2005 2:22 PM
Subject: Re: Table names with periods
Patrick,
I have been trying to figure out how I can convert an IP address to a 32bit
integer within a S
t;
>
> - Original Message -
> From: "Chance Ellis" <[EMAIL PROTECTED]>
> To:
> Sent: Wednesday, September 28, 2005 12:57 PM
> Subject: Re: Table names with periods
>
>
> Instead of criticizing people's designs without understanding the
&
From: "Chance Ellis" <[EMAIL PROTECTED]>
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.
Can't you use a single table instead of more tables?
Or each table has differ
>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`
Th
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
t ISP
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: "Chance Ellis" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, September 28, 2005 12:57 PM
Subject: Re: Table names with periods
Instead of criticizing people's designs without understanding the
>
>
>Instead of criticizing people's designs without understanding the
>requirements why don't you just answer the question, or don't you know
>either?
PS: As Shawn (who is more helpful in giving fast answers ;-) pointed
out: the answer can be found in the manual...
Which begs for another questi
re 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)
>
> Ehm. Why?
>
> Instead of going the "silly table names" route, why not try a diffe
27;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)
>
> Ehm. Why?
>
> Instead of going the "silly table names" route, why not try a different
> design?
>
>
>
>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)
Ehm. Why?
Instead of going the "silly table names" route, why not try a diff
Chance Ellis <[EMAIL PROTECTED]> wrote on 09/28/2005 11:56:53 AM:
> 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,
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
19 matches
Mail list logo