|
|
Posted by J.O. Aho on 08/17/06 14:50
_Raven wrote:
> I am getting an error when adding info to table. I am getting mysql error
> for duplicate entry.
You aren't giving any info on how your table looks like, so it's a bit more
guessing here.
I would use AUTO_INCREMENT for the uid column, this way you don't have to
inject it when you add a new user to your table.
INSERT INTO mytable (name,state) VALUES ('joe','texas')
> The column is a unique one, but the data I'm inserting is unique from the
> other entries.
Are all columns unique? then you limit quite much what you can enter into your
table, only the uid should be unique and a primary key.
//Aho
Navigation:
[Reply to this message]
|