Replace will be useful if you mean to delete the previous duplicates and then enter the new data. Moreover there is no REPLACE... SELECT like there is INSERT... SELECT which make life easy!
Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 11:12, Laercio Xisto Braga Cavalcanti wrote: > You can use replace command instead of insert. It will handle duplicate > rows. > > Regards, > > Laercio. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]