There is REPLACE... SELECT... http://dev.mysql.com/doc/mysql/en/REPLACE.html
Thanks Aman On Wed, 2004-07-21 at 11:32, aman wrote: > 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]
