Nick wrote:
The MySQL documentation link doesnt show the option for ON DUPLICATE
KEY for INSERT... SELECT...
On page http://dev.mysql.com/doc/mysql/en/INSERT.html:
"If you use an INSERT ... VALUES statement with multiple value lists or
INSERT ... SELECT, the statement returns an information string in this
format:
...."
Were you able to get it to work? -Nick
No, I'm using MySQL 4.0.20. So I can't offer any advice from my own
experience. I agree that it's a useful feature, but it's not standard
SQL. Since it's not working, it might be easier to code around it the
old-fashioned way. That is, fetch the dataset you want to insert, and
filter out entries that already exist in the destination table.
Regards,
Bill K.