Insert non duplicate data
- From: Leo <Leo@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2005 09:12:04 -0700
I'm trying to construct an insert statement which will only insert data if it
hasn't been inserted before in the same table, i.e. insert x,y into table
where not exists (select x,y from table), or some such statement. Is there an
easy way of doing this - maybe an if statement that selects x,y and if they
don't exist they are inserted? What would the syntax of such a query be?
.
- Follow-Ups:
- Re: Insert non duplicate data
- From: nickname
- Re: Insert non duplicate data
- Prev by Date: Re: prompt for parameter in a view
- Next by Date: Return Part of a text field
- Previous by thread: prompt for parameter in a view
- Next by thread: Re: Insert non duplicate data
- Index(es):