MySQL, perl, last_insert_id() question

Hi, I know that someone is going to say, "go ask the perl module guys" and I will but they are likely to say, "go ask the MySQL guys". I'll be asking in both groups. I am installing a script on a brand new RedHat, Fedora Core 7 (x86_64) box that is running MySQL 5.0.45 (rpm install). I also hav

Re: counting question

Thanks to all that responded about my counting question. Gleb Paharenko's solution using the sub-select and the LEFT JOINS was the closest to what I needed. All the best, Dean...K... -- Dean Karres / karres at itg dot uiuc dot edu / www.itg.uiuc.edu Im

counting question

Hi, I have three simple tables: user { id int PRIMARY name varchar UNIQUE } skill { id int PRIMARY skill_name varchar UNIQUE } user_skill { user_id int skill_id int UNIQUE KEY id (user_id, skill_id) } Each user can have zero or more associated skills. So you might have these a

breaking session start/stop datetime records on time/day bounds

IX_TIMESTAMPs and do the date manipulation myslef? Dean...K... -- Dean Karres / karres at itg dot uiuc dot edu / www.itg.uiuc.edu Imaging Technology Group / Beckman Institute University of Illinois 405 North Mathews / Urbana, IL

counting records and JOINS

EFT JOIN Decoration D ON D.level = PD.severity How should I do this? Is there a better way to do any of this? All the best, Dean...K... -- Dean Karres / karres at itg dot uiuc dot edu / www.itg.uiuc.edu Imaging Technology Group / Beckman I