in reply to Re: Re: Re: DBI and primary keys
in thread DBI and primary keys

It's not efficient, and it depends on your dataset, but what's to prevent you from doing a select for the primary key of the row that matches your data exactly?

If there's duplication of your values, you might have to order by the key, descending, and limit the results to one row... but you already have the exact values you've just inserted.

Replies are listed 'Best First'.
Re:(5) DBI and primary keys
by busunsl (Vicar) on Mar 28, 2001 at 00:30 UTC
    Well, think of doing this on a muti-million row table.
    Without an index on all columns, of course.

    You'll wait hours, perhaps even days!