I meant this how you can write a similar query in Oracle. On Fri, May 16, 2008 at 11:17 AM, Qasim Rasheed <[EMAIL PROTECTED]> wrote:
> This is something that I would do on Oracle > > INSERT INTO t_table > (tableid,table_name) > SELECT 1 AS tableid > , 'Table1' AS tablename > FROM dual > WHERE NOT EXISTS ( SELECT 1 > FROM t_user u > WHERE u.tableid = 1 ) > > > On Fri, May 16, 2008 at 11:12 AM, Rick Faircloth <[EMAIL PROTECTED]> > wrote: > >> Not being so well-versed in indexing (just starting using those in MySQL >> 5), >> I don't understand how having a unique index on the photo_filename column >> will prevent an insert of a duplicate value. >> >> Is that function a part of creating a unique index? Does it cause MySQL 5 >> to screen inserts for duplicates and reject them? >> >> ??? >> >> Rick >> >> > -----Original Message----- >> > From: Didgiman [mailto:[EMAIL PROTECTED] >> > Sent: Friday, May 16, 2008 11:04 AM >> > To: CF-Talk >> > Subject: Re: What's wrong with this query? >> > >> > You could always create a unique index on the photo_filename column. >> > >> > Wim. >> > >> > On Fri, May 16, 2008 at 4:57 PM, Aaron Rouse <[EMAIL PROTECTED]> >> wrote: >> > >> > > When I have done this, I used a NOT EXISTS, so something like this >> random >> > > example I just pulled from Google: >> > > >> > > http://archives.postgresql.org/pgsql-general/2003-06/msg01683.php >> > > >> > > On Fri, May 16, 2008 at 9:40 AM, Rick Faircloth < >> [EMAIL PROTECTED]> >> > > wrote: >> > > >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4