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:305436
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
