Ok , thanks Sim, now i see it
P
2011/9/5 Sim Zacks <s...@compulab.co.il>
> **
> 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.mu...@bioinf.uab.cat*
