Re: conditional insert

[Pau Marc Muñoz Torres <paumarc@xxxxxxxxx>]

Ok , thanks Sim, now i see it

P

2011/9/5 Sim Zacks <sim@xxxxxxxxxxxxxx>

On 09/05/2011 01:37 PM, Pau Marc Muñoz Torres wrote:

i don't  see it clear, let me put an example

i got the following table

molec varchar(30)
seq varchar(100)

where I insert my values

 lets image that i have a record introduced as ('ubq', 'aadgylpittrs')

how i can prevent to insert another record where molec='ubq' ?

thanks

Either put a unique constraint on molec or do
insert into tbl(molec,seq)
select 'ubq', 'aadgylpittrs' where not exists(select molec from tbl where molec='ubq')

-- 
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional   
Institut de  Biotecnologia   i Biomedicina Vicent Villar                                    

Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)
              
telèfon:  (+34)935 86 89 39
Email : paumarc.munoz@xxxxxxxxxxxxxx