Can't start mysql-service on Win XP

2002-04-28 Thread Sabine Richter
at failure number means, where to find something about it (who raised it: win or mysql?) and where to search for the reasons. I already searched for this failure in the mysql ref manual and in the win help system. I'll be grateful for any tip! Thanks in advance

Re: Can't start mysql-service on Win XP

2002-04-28 Thread Sabine Richter
Hi Jan, > > I suppose you already tried this: > http://www.mysql.com/doc/N/T/NT_start.html I did! > > This could be problems w/ your path or your my.ini (overwritten my > mysqladmin). mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that? In my.ini I just wrote "basedir=m

[Fwd: How get the columns that are between an interval?]

2002-04-28 Thread Sabine Richter
oops, i've just sent it to mike. Sabine Richter wrote: > > Hello Mike, hello Silvia, > > I think, the statement you suggest, Mike, isn't right. It gives you only > patients who are over 1 year in hospital. That means, who came before > (or at) 2000-01-25 and left

Using MyODBC with Python

2002-05-01 Thread Sabine Richter
Hello, I can't think straight today. So please help me: I downloaded and installed myODBC 3.51. As far as I understand, it is only the driver, which provides the connection to the database. In my example, it is MySQL 3.23.49. The manual says that in my application I have to allocate the environme

substitute for sub query with group function

2002-05-12 Thread Sabine Richter
Hello, I just want to get the value of one column in the row where max of another col of this table is. With the possibility of sub queries I would write: select col1 from table t1 where col2 = (select max(col2) from tab1e t2); But how to do it without a sub query? Just with 1 st

Re: substitute for sub query with group function

2002-05-12 Thread Sabine Richter
, 12 May 2002 23:04:14 +0200 > Sabine Richter <[EMAIL PROTECTED]> wrote: > > > Hello, > > > > I just want to get the value of one column in the row where max of > > another col of this table is. > > With the possibility of sub queries I would write: &

[Fwd: mysql query question]

2002-05-17 Thread Sabine Richter
Sorry, I've been too long in a list where you just answer the questioner and then the questioner writes a summary of the answers to the list. Sabine Sabine Richter wrote: > > Hello Taylor, > > as far as I see from the documentation and own trials you can just > del

[Fwd: Add existing related data to a table]

2002-05-17 Thread Sabine Richter
Sorry, I've been too long in a list where you just answer the questioner and then the questioner writes a summary of the answers to the list. Sabine Sabine Richter wrote: > > Hello Alexander, > > your problem is near to Taylor Lewick's and I have a similar suggestion >

[Fwd: Joining same table twice for different rows -- possible?]

2002-05-17 Thread Sabine Richter
Sorry, I've been too long in a list where you just answer the questioner and then the questioner writes a summary of the answers to the list. Sabine Sabine Richter wrote: > > Hi Ron, > > I suspect users.id and userid1 / userid2 have to be joined? > > Then: >

Re: Maximum JOINED tables

2002-06-05 Thread Sabine Richter
And how long does it take to compile a 32-tables-statement? With the gupta server a 14-tables-statement took 2 hours. Sabine "Weaver, Walt" wrote: > > Hmmm... we're running 3.23.47 here and have run into a 32 table join > limit... > > --Walt > > -Original Message- > From: Roger Baklun

Re: sub-queries

2002-06-06 Thread Sabine Richter
SELECT monitorhosts.HostID FROM monitorhosts, monitorhostgroupdetails WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID AND monitorhostgroupdetails.HostGroupID != '1'); Gruss Sabine Chris Knipe wrote: > > Lo all, > > are sub-queries supported on mysql-max 3.23.49 ?? > > If they are,