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
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,
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 table
Hi there,
Instead of criticizing people's designs without understanding the
requirements why don't you just answer the question, or don't you know
either?
That's why I asked why.
It's not uncommon that a faulty/suboptimal design leads to
questions for a problem that shouldn't be existing in 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 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
Try enclosing it in backticks like this. `#table`
Here is the url for reference:
http://dev.mysql.com/doc/mysql/en/Legal_names.html
On Fri, 3 Dec 2004 13:37:38 -0600, Daniel Kemper [EMAIL PROTECTED] wrote:
Hello,
As you may know, the mambo (open source CMS) table names
Neil,
Thank you for your suggestion. Unfortunately, the
Grant command grants privileges to lower case table
names also. I have also tried to find solution from
archive of mysql mail lists but nothing useful have
been found.
Kent.
--- Neil Silvester
[EMAIL PROTECTED]
wrote:
-Original
Hello All,
I need to create a series of MySQL tables with numerical value
name, which for
some reason I can't. IE:
CREATE TABLE 101 ( tagnumber varchar(8) not null default '' )
CREATE TABLE 201 ( tagnumber varchar(8) not null default '' )
CREATE TABLE 301 ( tagnumber varchar(8) not
Thanks. Guess I'll need to come up with another naming scheme. :)
On Mon, 29 Oct 2001 00:48:44 +0100, Carsten H. Pedersen
[EMAIL PROTECTED] wrote:
I need to create a series of MySQL tables with numerical value
name, which for
some reason I can't. IE:
CREATE TABLE 101 ( tagnumber
I need to create a series of MySQL tables with numerical value name, which for
some reason I can't. IE:
CREATE TABLE 101 ( tagnumber varchar(8) not null default '' )
CREATE TABLE 201 ( tagnumber varchar(8) not null default '' )
CREATE TABLE 301 ( tagnumber varchar(8) not null default '' )
I've
On Sun, 28 Oct 2001 22:59:46 -, DL Neil [EMAIL PROTECTED]
wrote:
I need to create a series of MySQL tables with numerical value name, which for
some reason I can't. IE:
CREATE TABLE 101 ( tagnumber varchar(8) not null default '' )
CREATE TABLE 201 ( tagnumber varchar(8) not null default '' )
24 matches
Mail list logo