select query question
I have a table where patient visits are logged each visit, the table is: patientnumber,visitdate,location I need to select and count the number of records that have 2 or more entries with the same patientnumber in sql-english: select count(*) where there are two or more records with the same patientnumber Any help with the SQL to do this would be much appreciated. Thanks! Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading
you need to grab the .i386.rpm files...you have the source code RPM. - Original Message - From: "Ben Ocean" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 10:14 AM Subject: Upgrading Hi; I'm trying to upgrade to the latest distro. I thought I could simply d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm When I do I get no error messages, but no upgrade seems to occur (i.e., I get the old version number at the mysql prompt). How am I supposed to do the upgrade? TIA, BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data modeling tool
I wish, ERWin is wonderful! - Original Message - From: "Cal Evans" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 10, 2001 6:41 PM Subject: Data modeling tool As much as I love creating models by hand, my databases are growing to the point where I need a tool to help me "see" them. Does anyone know of a tool like ERWin or ER/Studio that supports MySQL? Cal http://www.calevans.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Maximum Capacity and Stability
Well, only use Access if it's a small project. I've used both MS SQL, Oracle 7.3 and MySQL. My MS db is about 8 Gigs and I've only had to rebuild damaged tables once in the last year...I just upgraded it to SQL server 2000, and it seems fine so far, as well. Oracle, I had bunches of problems with..my db on oracle was around 5 gigs, but I got corruption like every few months..not sure what the problem was, but I don't use oracle anymore. I've been using MySQL for about 9 months now, for a linux project, the db is only a few hundred megs, but i've never had problems with it yet. Speed wise, in my projects, MS and oracle were about the same...with MySQL a little faster than both, but MySQL can't so some of the heavier stuff that MS/Oracle can...that's my experience with the three...it could be very different for you, though. jon - Original Message - From: "Joshua J. Kugler" [EMAIL PROTECTED] To: "Chan, Kwok-Hing" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 4:24 PM Subject: Re: Maximum Capacity and Stability I can't speak for the maximum capacities (but I think they are in the manual or FAQ) but as to stability, I've never had MySQL crash or corrupt a table, and I've been running it for several months; almost a year, actualy. j- k- On Thursday 08 February 2001 01:19, Chan, Kwok-Hing wrote: Can anyone tell me the maximum capacity (number of tables, records) of MySQL database, and the stability comparison with other databases like MS Access, Oracle, MS SQL, etc.? Since it is important for decision of database in my project. Thank you very much! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php