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: Bastian Balthazar Bux (BastianBalthazarBuxpnpitalia.it)
Date: Mon Oct 03 2005 - 16:46:23 CDT

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\([0123456789]\).\([0123456789]\)\.\([0123456789]\)\.\([0123456789]\)*NEEDTOREPLACETHIS/\1_\2_\3_\4/'
\
SAVEDFILENAME \
| mysql -ublabla -psecret dbname

You can do quite everyting from a cron script, also create sql query
from normal syslog logs.

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