Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Mikhail Berman (mikhailbergmail.com)
Date: Wed Dec 23 2009 - 08:16:09 CST
It seems to me that you might want to have two tables that will describe
data in your database
* - DOMAINS
* - IPS
DOMAINS table should contain two fields:
* `domain_key` - auto-increment
* `domain_name` - varchar(20)
IPS table should contain three fields
domain_key - int(10) - being a foreign key to DOMAINS table
ip_number - varchar(15)
ip_attribute - varchar(10)
Hoping this gives you some ideas how to handle this data.
> I have a table, which has a column named as "domain", each domain has
> some IPs, each IP has two attributes: "disabled","noticed".
> For example, the table:
> domain IP
> www.aol.com 22.214.171.124 126.96.36.199 188.8.131.52 184.108.40.206
> But I don't know how to control the IP's attributes if I set this
> Please help,thanks.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql