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
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
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
>
>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,
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
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
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
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 d
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 loo
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 10
> 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)
24 matches
Mail list logo
