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
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 SQL create statement.
Is this possible or am I thinking about this all wrong? The input I am given
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 SQL create statement.
You are mixing purposes. MySQL has a CREATE TABLE statement
clever people out there
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
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
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
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 SQL create
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 \
: [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
Replies embedded:
Patrick [EMAIL PROTECTED] wrote on 10/03/2005 03:43:20 PM:
There are many ways to approach this. How are you receiving the IP
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
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, Mysql is puking
on
format
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 different
design?
With regards
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?
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
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 question:
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: Chance Ellis [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, September 28, 2005 12:57 PM
Subject: Re: Table names with periods
Instead of criticizing people's designs without understanding the
requirements
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
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
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 different
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
either?
On 9/28/05, Martijn Tonies [EMAIL PROTECTED] wrote:
I am sure this has been asked
19 matches
Mail list logo