Re: table design question

[James M Moe]

rmck wrote:
I have "ip_address" and "ports" that I want to use in my table. I was just going to make each one a varchar. But was wondering if anyone has a better suggestion? 

Should I use int for "ports", which will have an index. Not sure how to store "ip_address".

  Use a varchar for the IP address. It allows greater flexibility and 
will adapt to format changes much more easily.
  An int for the port number would work well.

--
jimoe at sohnen-moe dot com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]