Re: Table names with periods

[Jasper Bryant-Greene]

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/