Wouldn't you do this in a loop? Where is the problem?
> I have two tables each with 12K records, I need to merge them into one single table
>and also check for duplicates. I'm thinking in doing it with PHP and Mysql. My idea
>involves one SELECT query and
> almost 12K insert query. Is there a faster way of doing using only MySQL?
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
