From: Mikhail Berman (mikhailbergmail.com)
Date: Wed Dec 23 2009 - 08:16:09 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Eva,

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.

Regards,

Mikhail Berman

Eva wrote:
> Hello,
>
> 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 64.12.245.203 64.12.244.203 64.12.190.33 64.12.190.1
>
>
> But I don't know how to control the IP's attributes if I set this
> table-stru.
>
> Please help,thanks.
>
> Eva.
>
>

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]