All Forums UDA
Greyghost 51 posts Joined 07/09
11 Aug 2009
Syntax needed

What is the proper syntax for using the "Insert ...not exists" code? Is there a pdf or some other documentation floating around that I can get that would be a good reference for these types of questions?I have a large table that I defined in the ddl as MultiSet. The table loads much faster now, but I still need to handle possible duplicate records (not just key because it is a NUPI, but entire record dups). What would be the best way to do this duplicate checking?Thanks!Paul

Bhanu 5 posts Joined 04/09
11 Aug 2009

This might help youhttp://www.xaprb.com/blog/2005/09/25/insert-if-not-exists-queries-in-mysql/

You must sign in to leave a comment.