LocK Manager in MySql

2005-06-28 Thread Parag Agrawal
Hi, I am a Computer Science student here at IIIT hybd and our team is going to implement a speculative lock manager in MySql 4.0 or higher. Can someone Plz tell if the mysql code shipped with FC2 has Two Phase Locking? or does any other version has it? or if any other commercial version has

Re: counting question

2005-07-31 Thread Parag Agrawal
Try this out: select user.name, skill.skill_name, count(user_skill1.skill_id) from user , skill, user_skill , user_skill as user_skill1 where user.id=user_skill.user_id and user_skill.skill_id=skill.id and skill.id = user_skill1.skill_id order by user.id. I think this would work. -- Parag B

Re: MySQL vs XML

2005-07-31 Thread Parag Agrawal
of application u want. - Parag Agrawal B. Tech IIIT On 7/30/05, David Blomstrom <[EMAIL PROTECTED]> wrote: > I've been gathering data for an animal kingdom > database for quite some time and am now trying to > figure out how to organize and display it. So far, I > have a