MySQL Lists: mysql: MAC address as primary key

List:	General Discussion	« Previous Message Next Message »
From:	Ilia KATZ	Date:	May 14 2009 1:26pm
Subject:	MAC address as primary key - BIGINT or CHAR(12)
View as plain text

Hi.
Currently I have a table:
1. MAC address defined as BIGINT
2. MAC address set as primary key
 
Should I consider changing it to CHAR(12)?
 
Replies will be appreciated.
Ilia

Thread
• MAC address as primary key - BIGINT or CHAR(12)	Ilia KATZ	14 May
• Re: MAC address as primary key - BIGINT or CHAR(12)	Fish Kungfu	14 May
• Re: MAC address as primary key - BIGINT or CHAR(12)	kabel	14 May
• RE: MAC address as primary key - BIGINT or CHAR(12)	Ilia KATZ	14 May
• RE: MAC address as primary key - BIGINT or CHAR(12)	Jerry Schwartz	14 May
• Re: MAC address as primary key - BIGINT or CHAR(12)	Thomas Spahni	14 May
• Re: MAC address as primary key - BIGINT or CHAR(12)	Jim Lyons	14 May
• RE: MAC address as primary key - BIGINT or CHAR(12)	Daevid Vincent	14 May
• Re: MAC address as primary key - BIGINT or CHAR(12)	Pete Wilson	14 May
• Re: MAC address as primary key - BIGINT or CHAR(12)	Jim Lyons	14 May
• Re: MAC address as primary key - BIGINT or CHAR(12)	Pete Wilson	14 May
• RE: MAC address as primary key - BIGINT or CHAR(12)	Gavin Towey	15 May
• Re: MAC address as primary key - BIGINT or CHAR(12)	Gavin Towey	15 May