MySQL Forums
Forum List  »  Newbie

Re: making a row unique
Posted by: Ray Chambers
Date: February 23, 2009 02:11PM

if i have a vrtcl table

vrtcl_key
vrtcl_name
vrtcl_server



and i set the key to unique on vrtcl_server vrtcl_name

can i have a combo entry but an entry that isn't the same?

so i can have

key name server
'a' 'john' 'abc123'
'b' 'john' '1234'

but get an error on insert to
'john' 'abc123'

Options: ReplyQuote


Subject
Written By
Posted
February 23, 2009 12:12PM
February 23, 2009 12:20PM
Re: making a row unique
February 23, 2009 02:11PM
February 23, 2009 02:41PM
February 24, 2009 11:45AM
February 24, 2009 03:03PM
February 24, 2009 09:37PM
February 23, 2009 12:33PM
February 23, 2009 12:56PM
February 23, 2009 01:00PM
February 23, 2009 01:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.