[Bristolbathpm] Mysqldump restoring and updating

[Lyle]

Alex Francis wrote:
>> Mark Hughes wrote:
>>     
>>> Hi Lyle,
>>> You could try the 'INSERT ... ON DUPLICATE KEY UPDATE' syntax
>>>
>>>       
> cool but watch out for bugs with this feature
>
> more:
> http://bugs.mysql.com/search.php?search_for=ON+DUPLICATE+KEY+UPDATE&status[]=Active&severity=&limit=30&order_by=&cmd=display&phpver=&os=0&os_details=&bug_age=0&tags=&similar=&target=&defect_class=all&workaround_viability=all&impact=all&fix_risk=all&fix_effort=all
>   

Just realized that this is MySQL specific, which makes future ports to 
MSSQL impossible.

Looks like I'm going to have to do a Transaction instead... Which should 
be fun as I haven't done any before :)


Lyle