OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Table names with periods

From: Jasper Bryant-Greene (jasperbryant-greene.name)
Date: Mon Oct 03 2005 - 16:20:49 CDT

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
> appears MySQL will not accept periods.

Have your cron script replace the periods in the IP addresses with
underscores before importing the SQL into MySQL.

--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql