Alex Francis wrote: > On Wed, Jul 9, 2008 at 10:49 PM, Lyle <[EMAIL PROTECTED]> wrote: > >> Mark Hughes wrote: >> >>> Hi Lyle, >>> You could try the 'INSERT ... ON DUPLICATE KEY UPDATE' syntax >>> >>> > ... > >> That sounds pretty interesting. I'll have a play about with it and see >> what I can get working... Thanks for the pointer. >> >> > > ... > > cool but watch out for bugs with this feature > > e.g. > http://bugs.mysql.com/bug.php?id=29941 > > 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 >
Damn, that's pretty worrying, I've just written some important code using this feature :( Lyle _______________________________________________ BristolBathPM mailing list [email protected] http://mailman.bristolbath.org/mailman/listinfo/bristolbathpm
