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=arch...@jab.org
