On 10-Feb-2004 Seena Blace wrote: > Hi, > I want to create a table with composite Primary key.How to do that? > create table ipdet > (IPaddress varchar (14) not null , > hostid varchar (20) not null primary key (ipaddress,hostid), > IP_DESC text , > MAC text, > interface text); > thx-seena >
CREATE TABLE ipdat ( IPaddress varchar (14) not null , hostid varchar (20) not null, IP_DESC text, MAC text, interface text, PRIMARY KEY (IPaddress, hostid) ); > > --------------------------------- > Do you Yahoo!? > Yahoo! Finance: Get your refund fast by filing online -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
