help design the table

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
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: help design the table

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
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: help design the table

>-----Original Message-----
>From: Mikhail Berman [mailto:mikhailber@gmail.com]
>Sent: Wednesday, December 23, 2009 9:16 AM
>To: Eva
>Cc: mysql@lists.mysql.com
>Subject: Re: help design the table
>
>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)
>
[JS] Quick reminder: domain names can be much longer than 20 characters.
Otherwise, your suggestion is wise.

Also, Eva, you should check out the MySQL functions INET_ATON(expr) and
INET_NTOA(expr). Before you use them, though, check to make sure they handle
IP6 addresses. If they do, then you should store your IP addresses as
integers.
>
>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
>To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartz@the-
>infoshop.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org