List:General Discussion« Previous MessageNext Message »
From:Sameer Maggon Date:May 20 2002 7:41am
Subject:query - primary key
View as plain text  
Hi, 
  I have a table with four colums
  
  id
  date
  time
  addr - varchar (used my sql C API)

  I want that when i add an entry, the PRIMARY KEY IS ALL OF THEM
  means that no entry should repeat.

  I used ALTER TABLE sss ADD PRIMARY KEY (all four field)

  but not when i add my things, after 104 items, it gives an
  error, DUPLICATE ENTRY
  I have checked the file, they are not duplicate
  What do i do
  

  Please help
  Sameer





--------------
http://www.dypatil.edu For Better tomorrow
Thread
query - primary keySameer Maggon20 May
  • Re: query - primary keyDan Nelson20 May
Re: query - primary keySameer Maggon20 May
  • Re: query - primary keyDan Nelson20 May
Re: query - primary keySameer Maggon20 May
Re: query - primary keyAmer Neely20 May