In the last episode (May 20), Sameer Maggon said:
> 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
Paste in the full error message, and if you made 'id' a TINYINT
AUTO_INCREMENT, think very very carefully about the rage of a TINYINT.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
