NYCPHP Meetup

[Allen Shaw]

Hi Joseph,

You may be experiencing a bug in MySQL.  See this:
http://bugs.mysql.com/bug.php?id=8732

What do you think?

- Allen

Joseph Crawford wrote:

> the primary key is the session id so it should find a duplicate key 
> just fine.  when i enter the query into phpmyadmin when there are no 
> matching records it says it inserted one record, then when i do it 
> again it says it inserted 2 records this leads me to believe that it 
> deletes the existing record then inserts the new but that's not how 
> the docs say it's supposed to work.  REPLACE uses that functionality 
> not the UPDATE KEY


-- 
Allen Shaw                                
Polymer (http://polymerdb.org)
Fine-grained control over how your users access your data: 
user permissions, reports, forms, ad-hoc queries -- all 
centrally managed.