On 11/28/06, Nicolas Williams <[EMAIL PROTECTED]> wrote:
On Tue, Nov 28, 2006 at 03:03:58PM -0600, Isaac Raway wrote: > Use an index on the table with your key values and call "INSERT OR > UPDATE INTO t(...) VALUES(...)" for all creation and update > operations. Unless you're dealing with a tremendous amount of data per > record this will be perfectly efficient.Surely you mean INSERT OR REPLACE ... ^^^^^^^
Actually... yes. Not sure what version of SQL I was thinking of. Probably the one in my head. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
