select query question

2001-05-02 Thread Jon Rosenberg

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

2001-02-12 Thread Jon Rosenberg

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

2001-02-10 Thread Jon Rosenberg

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

2001-02-08 Thread Jon Rosenberg

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