re[2]: Could we make this a web discussion forum?

2003-03-31 Thread Richard Morton
I am with you jeremy... Web based discussion boards are horrible. I never remember to 
go daily. I can write my responses to this on the train and send them when I get to my 
desk.

Rich


   On Mon, Mar 31, 2003 at 12:52:43AM -0800, Seth Brundle wrote:
   
I really hate mailing lists - they are dinosaurs for this type of thing.

   I really hate on-line forums.  They're difficult to track because I
   must remember visit them daily.  And I can't use them while
   disconnected.  With e-mail, I download it all in one shot and read it
   anywhere.  I can write responses, queue them up, and send 'em when I
   have a connection.

A web discussion board is a much more powerful and flexible tool for
this type of community.

   Hmm.  E-mail has been around for a long, long time.  I'm skeptical of
   this claim.

Thread tracking, archiving, searching

   E-mail gives you all of those.

dont have to download 50 emails a day just to monitor a couple
threads...cmon its 2003!

   That sounds like a problem with your choice of mail tools, unless I'm
   mis-understanding your gripe.

Cant we convert this into a discussion board or better yet just make
the usenet group mirror postable from google groups?

   I believe there is already a read-only NNTP mirror of this group.

There are 4 lists like this one where I have to continuously
subscribe and unsubscribe throughout the year when I want to
participate.

   Why must you subscribe and unsubscribe to participate?  There's no
   membership requirement to post here.  And you can always read the
   messages on-line.  There are at least 2 web archives of this group.
   You've seen those, right?  I know that Google has.

Also emails get mirrored on google groups for convenient spam
harvesting - its really a pain in the butt.

   How would using a web forum help that?

   Jeremy
   -- 
   Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
   [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

   MySQL 4.0.8: up 55 days, processed 1,882,414,788 queries (389/sec. avg)

   -- 
   MySQL General Mailing List
   For list archives: http://lists.mysql.com/mysql
   To unsubscribe:   
   http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



re: ERWin 4.1 not applicable for MySQL

2003-03-31 Thread Richard Morton
You could try:

Datanamic's Dezign - www.datanamic.com

or you could use MS Visio Professional

HTH

Richard


   Dear MySQL users developers and programmers,
   ERWin  4.1  not applicable for MySQL

   I'd like to model some logical databases in Entity Relationships
   diagrams 
   From here I found interesting software

   URL:
   http://www3.ca.com/trials/

   https://www3.ca.com/register/form.aspx?cid=8403



   Download ERwin 4.1 Evaluation Software 
   ftp://ftp.ca.com/pub/erwin/EvalLic/ERwin41SP2-2765.exe


   According to the Documentation this visual tool supports a variety of 
   databases: 


   Target Databases Supported by ERwin

   Desktop Databases 

   Microsoft Access
   Clipper
   DBASE IV
   FoxPro
   Paradox

   SQL Databases

   AS/400
   DB2 390
   DB2 UDB
   HiRDB
   INFORMIX
   Ingres II
   InterBase
   ODBC Generic
   OpenIngres
   Oracle
   PROGRESS
   Rdb
   Red Brick Warehouse
   SAS
   SQL Anywhere
   SQLBase
   SQL Server
   Sybase
   Teradata
   WATCOM/SQL Anywhere
   
   Since I am fond of MySQL I'd like to know your opinion,
   Is it possible to access MySQL  from AllFusion ERwin Data Modeler ?

   What design tool do you use under Windows or Linux for modeling a
   logical 
   database ? 

   Yours Sincerely

   Morten Gulbrandsen

   


   -- 
   MySQL General Mailing List
   For list archives: http://lists.mysql.com/mysql
   To unsubscribe:   
   http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



MySQL v SAB DB

2003-02-25 Thread Richard Morton
Hi,

My fledgling product is based around a MySQL database, my _first_ customer is 
asking me to use SAB DB. Obviously this means a bit of re-engineering work and 
extensive testing. I am looking for peoples experiences of SAP DB, so that I 
can build a case for continueing with MySQL, (other than that the product works 
fine with MySQL)

Does anyone have such experience.

Is the support as good as MySQL?

From what I can see, it is a fully featured DB engine.

Thanks

Richard

-
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



Highly Reliable MySQL Installations

2003-02-20 Thread Richard Morton
Hi,

I am looking for advise on producing a MySQL platform which is reliable (i.e. 
fault resilient).

I am not sure how, using MySQL's technology I can have two systems each one 
mirroring the other, and if the primary server fails, how the system can 
automatically use the other server for all DB access.

What is the avg latency on the slave server in Replication?

Any Ideas or Suggestions on this?

Thanks

Richard

-
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[2]: InterBase vs. Mysql

2003-02-18 Thread Richard Morton
Actually, I think you are not quite right in all respects. but feel free to correct me 
if I am wrong

Somebody, or some entity still needs to hold the copyright of a product.

How that entity chooses to sell or distribute that product is up to them.

In this case MySQL AB is the copyright holder.

They have a fast, highly reliable product which meets the need of the majority of 
web-developers (and other developers).

It is not as feature rich as, say Interbase or MSSQL Server.

(I would love triggers and stored procedures, so that I can store business logic in 
the RDBMS)

This is my interpretation (after clarification from MySQL, and www.mysql.com ), of 
MySQL's licence: 

If a product is inherrently tied to using MySQL, i.e. without MySQL it would need 
re-development, alteration, or would not work. And you are profiting from the sale of 
that product, then MySQL insist a license should be purchased.

If the product is DB Agnostic or if the product is open-source and is distributed 
under GPL, then it doesn't need a license.

Basically, if you profit from MySQL's work, they want a very modest fee for there 
effort (much cheaper then other traditionally commercially available RDBMS.)

HTH,

Richad





   I'm not here to slag MySQL, but this point is extremely interesting.

   Benjamin Pflugmann wrote:
Aehem. There seems to be some misconception here. Either your program
is fine with MySQL being GPL or not.
   
If it is (and your forking example would work for you) either by using
MySQL in a way that your program is not required to be GPL'ed or by
GPL'ing your program, you need no commercial license from MySQL AB
either, and you can already distribute your program with MySQL without
the need of a fork or whatever.
   
Or your program needs a commercial license, than forking MySQL would
not help, because you still have to adhere to the GPL. The only reason
MySQL AB can hand out a commercial license is because they are also
the Copyright holders, which you aren't even after forking.

   There is also some middle ground here.  Which is the overlap of the two. 
   Where the user (me) wants to use a OSS DBMS, is happy to forward the 
   source code, inform the customer of the GPL licence etc.

   But at the same time produce a commercial application which then uses 
   this installed DBMS server/client, without effecting the GPL package.

   MySQL say that this is an extension of the application, and therefore 
   breaks the GPL, and therefore a licence is needed.  They are however, 
   the only big GPL user who thinks this way.  I note for example the 
   number of companies selling commercial CGI software designed to run on 
   Apache, server/client, to which no licence is mandatory.  Also Sendmail, 
   GCC, other DBMS's, and indeed GNU/Linux it's self.

   None of these very large groups consider a licence *mandatory* for use 
   when supporting a commercial application.  I use the term 'mandatory', 
   they may still choose to purchase a licence.  If they did insist on a 
   licence, a very large number of very large companies would have to 
   withdraw a very large number of products.  Eg, IBM who use Sendmail to 
   support their commercial email servers.

   Therefore, I can see no reason why not somebody could fork MySQL into 
   FreeSQL.  It would take a few hours at SorceForge, a 'sed' of MySQL into 
   FreeSQL', and a good posting to Slashdot.  Keep it 100% GPL without 
   breaking either the wording or the spirit of the document.  Remove all 
   reference to copyright material belonging to MySQL.  It's either GPL or 
   cpryright, not both.   Then use this without commercial licence...

   BTW, as to another posting.  'Either accept the GPL or purchase a 
   licence'.  I do note another option (apart from forking):  Use something 
   else.  Is MySQL really that good?  I do worry that with arrogant 
   statements like this, this is exactly what people will do, in droves. 
   If that's okay with you, well...




   
HTH,
   
Benjamin.
   



   -
   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[2]: Can MySQL work on Windows XP?

2003-02-10 Thread Richard Morton
Hi,

Yes MySQL will work on XP-HomeEd 

To start it...

open a command prompt, do this by...

Start - Run - cmd.exe
 then
cd c:\mysql\bin
mysql-nt.exe
this has started a mysql db engine.
the command prompt will not return.

to install it as a service instead do the following instead of the above
Start - Run - cmd.exe
 then
cd c:\mysql\bin
mysql-nt.exe --install
net start mysql


in either case you now have to open a console window. do the following.
Start - Run - cmd.exe
 then
cd c:\mysql\bin
then type 
mysql.exe

this will open a console window for you to control the mysql db engine


HTH Rich

  Does it (mysqld-shareware.exe) show up in the task managers listed
   processes?

   If not, it is not running (which is what I suspect).  Through my
   experience with it, the DOS box does not close.

   Try opening a DOS box and starting it (type 'cmd' in the run box) and
   see what error comes up.

   If you are still stumped there, write again and include the error
   message and the c:\windows\my.ini and-or c:\my.cnf settings.

   -- 
   Loren McDonald
   [EMAIL PROTECTED]

   -Original Message-
   From: Marg Brazil [mailto:[EMAIL PROTECTED]] 
   Sent: Thursday, February 06, 2003 11:31 AM
   To: MySQL
   Subject: Can MySQL work on Windows XP?

   Hello,
   Can anyone tell me if MySQL will work on Windows XP Home Ed.?
   I have MySQL installed according to the instructions on the CreateASite 
   web page.

   I tried contacted CreateASite with this description of the problem:

   The start up looks good: when I use the Run function 
   C:\mysql\bin\mysqld-shareware.exe, the black DOS box comes and goes, but

   I'm getting this error when using the  MySQL test script (See below):
   Warning: mysql_connect() [function.mysql-connect]: Can't connect to 
   MySQL server on 'localhost' (10061) in c:\usr\htdocs\mysql_test.php on 
   line 7
   Couldn't Connect
   I have followed the instructions for installing IndigoPerl, 
   CreateASite,  PHP, and for MySQL on
   www.createafreewebsite.net/mysql.html.
   Apache was running well at the time, and the perl and php test scripts 
   were A-OK.
   Should MySQL show in WindowsXP task manager? I can only see 2 
   Apache.exe' s and HTMel30.exe. There's no 
   C:\mysql\bin\mysqld-shareware.exe listed. 

   CreateASite response was:

   I worked with a guy from Germany for 2 days trying to get the mysql 
   package you are using to work on XP.   No luck.  I should probably put 
   that on the site.
   I'm not saying you can't get the present package to work.  Just saying I

   didn't on XP.  

   Has anyone in this discussion group had success getting MySQL to work on

   Windows XP?

   Thanks!

   MB



   MySQL test script:

   html
   head
   titleMySQL Test/title
   /head
   body
   ?
   $link = mysql_connect(localhost);
   if (! $link)
   die (Couldn't Connect);
   $db_res = mysql_list_dbs($link);
   $num = mysql_num_rows($db_res);
   for($x=0;$x  $num; $x++)
   print mysql_tablename( $db_res,$x).br;
   mysql_close($link);
   ?
   /body
   /html






   -
   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









Regards,

Richard Morton
Quantum Communications
+44 (0) 7899 750400

[EMAIL PROTECTED]
www.quantum-comms.com


-

This email, its content and any attachments is PRIVATE AND CONFIDENTIAL to
Quantum Communications and is intended for the recipient(s) named above only. 
If received in error please notify the sender and destroy the original 
message and attachments. Emails may be monitored or recorded. It is the 
responsibility of the recipient to ensure that the e-mail and/or any 
attachment is virus free. The views expressed by the author may not reflect 
the views of Quantum Communications Limited.

-

-
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




Off Topic - PHP/Mysql Development company

2003-02-03 Thread Richard Morton
Hi,

I am sorry this is a bit off topic.

I am looking for recommendations of MySQL / PHP / HTML / Javascript development 
companies. 

Companies which you have previously worked and found to be very good at what 
they do and good value.

They need to be English speaking. I am especially looking for companies in 
south of the UK.

I have previously used a company in India and I am not averse to trying this 
again.

Suggestions anybody...

Thanks to all.

Richard

SQL

-
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




Off Topic - PHP/Mysql Development company

2003-02-03 Thread Richard Morton
Hi,

I am sorry this is a bit off topic.

I am looking for recommendations of MySQL / PHP / HTML / Javascript development 
companies. 

Companies which you have previously worked and found to be very good at what 
they do and good value.

They need to be English speaking. I am especially looking for companies in 
south of the UK.

I have previously used a company in India and I am not averse to trying this 
again.

Suggestions anybody...

Thanks to all.

Richard

SQL

-
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[2]: Backups mechanism

2003-01-07 Thread Richard Morton
Hi,

I agree with the post... I feel there should be an inbuilt backup routine.

(maybe built into something like MySQLFRONT or MyCC.)

The shell script below, as far as I understand will not work with InnoDB only MyISAM 
tables. (please correct me if I am mistaken)

It seems that MyCC is far far far behind commercial GUI's, but I feel that this is 
one part of the product that most people, even ISP's who use MySQL for free would pay 
for - i.e. a GREAT fully integrated MySQL GUI.

Thanks

Richard





  What we have done it right a small script:
  It logs on to the MySQL server. 
  It then locks the databases and tables we have put in a config file.
  Simply copies the data files to a new directory. 
  Unlocks the tables.
  Once this is done (copy if fast) you can tar or zip up the copied files.
  Simon


  -Original Message-
  From: Jonas Widarsson [mailto:[EMAIL PROTECTED]]
  Sent: 07 January 2003 15:07
  To: [EMAIL PROTECTED]
  Subject: Backups mechanism


  Hello world!
  Every attempt I have made to find a decent way of backing up a database 
  ends up with tons of reading to show hundreds of ways to do database 
  backups.

  I want to know which way to do complete backups is most commonly used by 
  professional users. (Windows and Linux)

  I have pleasant experience from Microsoft SQL Server 2000 where backung 
  up is very confident, easy to understand and just a matter of a mouse
  click.

  Is there any similarily convenient way to do this with mysql, for example:
  * a shell script (windows / Linux) that works as expected without days 
  of configuration?
  * scheduled backups, complete or differential?
  * GUI-solution ??? (mysql control center does not even mention the word 
  backup)

  Backup is such an important issue. Why does it seem like it is something 
  that the developers don't care about?


  -
  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









Regards,

Richard Morton
Quantum Communications
+44 (0) 7899 750400

[EMAIL PROTECTED]
www.quantum-comms.com


-

This email, its content and any attachments is PRIVATE AND CONFIDENTIAL to
Quantum Communications and is intended for the recipient(s) named above only. 
If received in error please notify the sender and destroy the original 
message and attachments. Emails may be monitored or recorded. It is the 
responsibility of the recipient to ensure that the e-mail and/or any 
attachment is virus free. The views expressed by the author may not reflect 
the views of Quantum Communications Limited.

-


-
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[2]: MySql 4.1 Sub Selects

2002-11-11 Thread Richard Morton
Hi

according to this link... 4.1 will have stored procedures

http://www.mysql.com/products/mysql-4.0/index.html

Rich




   With the efficiency comment below, I was using the strategy that I'd
   prefer
   to wait for 4.1's impending (?) release rather than rewrite SQL in a
   workaround way. It's a tradeoff based on our specific project and relating
   to time factors, etc, and the amount of SQL I'd have to rewrite.

   Yes i'm sure the hurdle could be overcome but I'd rather hold back on
   MySql
   support until subselect functionality is ready.


   Typically, database vendors seem to recommend using EXISTS because the
   query
   returns on finding the first row that meets whatever the subselect
   criteria
   is.

   Do those people working on 4.1 anticipate the performance of the MySql sub
   select functionality to be better than an equivalent query written as a
   join? I guess any answer to this should also include consideration of
   sometimes putting DISTINCT in the select statement.

   Thanks a lot,
   Greg.

   - Original Message -
   From: Michael T. Babcock [EMAIL PROTECTED]
   To: Greg Matthews [EMAIL PROTECTED]
   Cc: [EMAIL PROTECTED]
   Sent: Monday, November 11, 2002 11:16 AM
   Subject: Re: MySql 4.1 Sub Selects


Greg Matthews wrote:
   
clause) instead of EXISTS -- seems like a tail wagging the dog
   strategy.
Isn't EXISTS a lot more efficient than an inner join?

   
Well, its more efficient if it exists, I guess ... but if it doesn't
exist on your platform (MySQL), then its pretty inefficient, really.
   
We're going to offering the application on Oracle and so I wouldn't
   like
   to
de-optimize the SQL just so it works on mysql 4.0 if 4.1 will be out
   within
a few months.

   
If you're writing OO code, you might be able to easily flag your objects
as to whether to use one or the other query based on the underlying
database system (queried at run-time).
   
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
   
   


   -
   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









Regards,

Richard Morton
Quantum Communications
+44 (0) 7899 750400

[EMAIL PROTECTED]
www.quantum-comms.com


-

This email, its content and any attachments is PRIVATE AND CONFIDENTIAL to
Quantum Communications and is intended for the recipient(s) named above only. 
If received in error please notify the sender and destroy the original 
message and attachments. Emails may be monitored or recorded. It is the 
responsibility of the recipient to ensure that the e-mail and/or any 
attachment is virus free. The views expressed by the author may not reflect 
the views of Quantum Communications Limited.

-

-
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: Info on 4.0.x release date

2002-08-27 Thread Richard Morton

Hi Will,

As far as I have heard (from MySQL) is that MySQL 4.0.3 is being made ready for Beta 
as we speak and is likely to be released in the next month. V4.1 will most likely be 
released Early Sept in Src form and in Binaries two months later.

4.0.x branch will be allowed to stabalise from the release of 4.0.3, through the 
normal Beta, Gamma and Stable routine.

In fact I believe there was an email to this effect earlier today

Rich



   When will 4.0.x finally be released to beta?

   The facts as I understand them:
   - 4.0 went alpha in Nov or Dec of '01
   - At the time, Monty and his gang projected stabilization by Jan or Feb
   - More than 6 months have passed since and the product is not yet
   stabilized
   - No meaningful information has been released about what a more realistic
   date might be
   - Anytime anyone dares to stick their head up and inquire about this
   issue,
   they get their hat handed to them with a glib when its ready response

   It is impossible for me to believe that I am the only one frustrated by
   this.  I spent months evaluating the suitability of MySQL for our systems
   last summer/fall.  At that time I made the determination that it would be
   quite well suited, but only with the addition of some functionality
   promised
   in 4.0 and 4.1.

   It is not my intention to put the MySQL team on the defensive about this
   --
   I know they are working incredibly hard.  I do not, however, feel it is
   unreasonable for the user community to ask for more information about
   upcoming releases.  I know that you are probably thinking that I don't
   have
   the right to be demanding when the software is free.  Well guess what, it
   isn't!  Every company that uses MySQL spends money on it (remember,
   licensing represents only a small fraction of total cost of ownership).
   Furthermore, MySQL AB is a for-profit venture whose fortunes are tied to
   the
   continued spread and use of their flagship open-source product.

   So... How about cluing us in on what's left to do, what progress has been
   made and a best-guess as to what the release schedule might look like.  I
   wouldn't worry too much if your dates slip over time (I think you will
   find
   a sympathetic group), but just keep us updated so we can adjust our own
   plans.

   Thanks

   Will French


   ==
   
   NOTE:  The information in this email is confidential and may be legally
   privileged.  If you are not the intended recipient, you must not read,
   use or disseminate the information.  Although this email and any
   attachments are believed to be free of any virus or other defect 
   that might affect any computer system into which it is received and
   opened, it is the responsibility of the recipient to ensure that it is
   virus free and no responsibility is accepted by Cadwalader, Wickersham
Taft for any loss or damage arising in any way from its use.


   ==
   


   -
   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




Versions

2002-08-21 Thread Richard Morton

Hi,

I am looking for dates for new versions and the bug fixes they will have contained.

I am using 4.0.1... however I have a handles leak. I have been told by another source 
that this will be resolved in 4.1

My question is, using MyODBC(3.51.03)... Is this a problem with 3.x stable releases or 
just 4.0.x alpha releases.

If this is an issue with both, does anybody know when this will be fixed or what 
versions don't have a problem?

Does anybody else suffer with this? Has anybody found a resolution?

Thanks

Rich



Filter Fodder: SQL

-
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[2]: MySQL Errors -

2002-07-23 Thread Richard Morton

What instances can cause a Table to crash?

Is this caused by a bug in itself, a power failure, or something else?

Richard

   William_dw,
   Tuesday, July 23, 2002, 10:34:16 AM, you wrote:

   WS I'm hoping someone can give me a pointer as to what's going wrong
   that's
   WS crashing our MySQL server, I've included a snippet of the log (for the
   last
   WS time it restarted and then the errors after that).

   WS I've been trying to read through the 'Debugging MySQL server' section,
   but
   WS there doesn't seem to be much to go on from the log, and the 'if you
   don't
   WS see anything something went terribly wrong' message with nothing but
   an
   WS 'aborting backtrace' message after it kinda has me worried over here.

   WS Any suggestions, pointers, or anything else would be really
   appreciated as
   WS my hair is turning gray by the second :).

   WS Thanks in advance,
   WS William.


   WS mysqld got signal 11;
   WS The manual section 'Debugging a MySQL server' tells you how to use a
   WS stack trace and/or the core file to produce a readable backtrace that
   may
   WS help in finding out why mysqld died
   WS Attemping backtrace. You can use the following information to find out
   WS where mysqld died.  If you see no messages after this, something went
   WS terribly wrong
   WS Bogus stack limit or frame pointer, aborting backtrace

   WS Number of processes running now: 0
   WS 020722 08:55:42  mysqld restarted
   WS /usr/sbin/mysqld: ready for connections
   WS 020722  8:55:45  read_key: Got error 127 when reading table
   WS './wahse/keywords'

   $ perror 127
   Error code 127:  Unknown error 127
   127 = Record-file is crashed

   Your table is crashed. You should repair it using myisamchk:
   http://www.mysql.com/doc/m/y/myisamchk_repair_options.html
   http://www.mysql.com/doc/R/e/Repair.html




   -- 
   For technical support contracts, goto https://order.mysql.com/?ref=ensita
   This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
   / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
   /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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: newbie SOUNDEX question

2002-06-07 Thread Richard Morton

Hi,

You are doing everything fine, however, soundex is not a perfect system and does not 
always work. It does simplify some types of queries. But in the vast majority of cases 
I don't think that it is worth the bother. 

It doesn't actually link all the same sounding sirnames, if there were a system like 
that life would be nice and simple, however (and correct me if I am wrong) there isn't 
one. Soundex was an attempt and it doesn't really work. It is used by the US 
government but it just means you have to search under a couple of different soundex 
codes rather than searching under 8 or 9 different spellings.

See this example.

mysql select soundex('morton'), soundex('moreton'), soundex('morten');
+---++---+
| soundex('morton') | soundex('moreton') | soundex('morten') |
+---++---+
| M635  | M635   | M635  |
+---++---+
1 row in set (0.00 sec)

mysql select soundex('callaghan'), soundex('callahan'), soundex('calahan');
+--+-++
| soundex('callaghan') | soundex('callahan') | soundex('calahan') |
+--+-++
| C425 | C450| C450   |
+--+-++
1 row in set (0.00 sec)
mysql


I hope this helps.

Richard


   I want to use SOUNDEX for name queries, but I don't 
   seem to be doing it correctly. 

   As a test, I made a small table and popluated it 
   with my name. My goal is to be able to find my name 
   'Callaghan', with its most common misspelling 
   'Callahan'. 

   I've read the MySQL doc, so I know how to actually 
   invoke soundex at the mysql prompt. I read an 
   article that said soundex queries move more quickly 
   if you add a column for the soundex.

   Thus:

   CREATE TABLE sound (
   id tinyint(3) NOT NULL auto_increment,
   name varchar(100) default NULL,
   sound varchar(100) default NULL,
   PRIMARY KEY  (id)
   ) TYPE=MyISAM;

   select soundex('Callaghan');
   result = C425

   INSERT INTO sound VALUES (1, 'Callaghan', 'C425');

   Simple enough. Now, I expected all three of the 
   following queries to return a value. 

   select id from sound where sound = 
   soundex('Callaghan');
   returns 1 records

   select id from sound where sound = 
   soundex('Callahan');
   returns 0 records

   select id from sound where name = 
   soundex('Callaghan');
   returns 0 records

   I'm missing something obvious here, but I've read 
   the doc and I'm not sure what's wrong.

   -- 
   Get your free email from www.linuxmail.org 




   Powered by Outblaze

   -
   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




FWD: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490

2002-05-17 Thread Richard Morton

please see below


-- Forwarded Message --

FROM:  euro.support [EMAIL PROTECTED]
TO:  Richard Morton [EMAIL PROTECTED]
DATE:  Fri, 17 May 2002 10:26:06 +0200

RE:  RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490


Hi Richard,

I have received an answer from our dev team, please see below:

--
MySQL does not accept 
SQLSetConnectAttr function for setting the 
SQL_ATTR_CONNECTION_TIMEOUT
which is added recently to the same value as the query timeout.

Unfortunately although it is legal ODBC 3.0 parameter MySql crashes instead of 
reporting error if it does not support it. This should be considered MySQL bug.

Code is changed in PU 8 not to call this function if timeout is set to 0.
I will post here just a FDbase.fdl which can be used even on PU007 Release.
But customer still needs to change its script to set query timeout to 0.
-- 

Attached you can find the FDbase.fdl file, just unzip it into your Envox folder, then 
change your script as stated above.

Please let us know the outcome of this.

Best regards,
___

Andreas Persson
Technical Support

Envox EMEA 
Söder Mälarstrand 43
118 25 Stockholm
Sweden

www.envox.com

Tel: +46 (0)8 56 256 000
Dir: +46 (0)8 56 256 062
Fax: +46 (0)8 56 256 050
mailto:[EMAIL PROTECTED]


-Original Message-
From: euro.support 
Sent: den 16 maj 2002 16:25
To: 'Richard Morton'
Subject: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490



Hi Richard,

I have not been able to reproduce the same problem herehowever I have sent this 
further to our developers so they can have a look at it as well.

I'll get back to you as soon as I hear anything from them.

Best regards,
___

Andreas Persson
Technical Support

Envox EMEA 
Söder Mälarstrand 43
118 25 Stockholm
Sweden

www.envox.com

Tel: +46 (0)8 56 256 000
Dir: +46 (0)8 56 256 062
Fax: +46 (0)8 56 256 050
mailto:[EMAIL PROTECTED]


-Original Message-
From: Richard Morton [mailto:[EMAIL PROTECTED]]
Sent: den 16 maj 2002 05:34
To: euro.support
Subject: FWD: ECS Error with 4.0.07 opening DB (still) again



Hi Guys,

Sorry I lost the last email so I don't know the ticket number...


Continuing problem
I have just rebuild my system completely to remove any possibility of that causing the 
problem. (look at the time of this msg!). 

Any way: What am I using...

D/120JCT-LS
MyODBC and MySQL 4.0
Dialogic SR 5.01
Envox 4.0.07
Nuance v7.0.4a SP23.

See attached files.

On the installation I said 'Yes' to installing the MS MDAC 2.7

Basically I cannot open a DB connection with this version of Envox, it was working 
with 4.0.07 RC4 but not with this released version!

Let me know what info you need. ( I have attached a simple application script which 
doesn't work )


Thanks for your help guys!

Rich
+44 (0) 7899 750400

-
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: backslash about MySQL++/Microsoft Visual C++ 6.0 (2)

2002-05-02 Thread Richard Morton

Hi,

I have had a similar problem...

This also occurs with ' or .

in any field you expect this character use:

REPLACE(c:\mysql\test,\,/)
Returns the string str with all all occurrences of the string from_str
replaced by the string to_str:
mysql select REPLACE('www.mysql.com', 'w', 'Ww');
- 'WwWwWw.mysql.com'

to change '\' to '/'

Rich

-Original Message-
From: Joerg Geistmann [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 1:59 PM
To: Mysql-De; MySQL Win32; MySQL Plusplus
Cc: Lazy Fox
Subject: RE: backslash about MySQL++/Microsoft Visual C++ 6.0 (2)


hello again!

sorry, i know that i must use dopple backslash in c++ ;-)
my problem is really to get backslash in database about
mysql++/vc (1.7.1)
also i try

 Query  insert into blafasel values ('1', 'c:\\mysql\\test', '0');

i doesn´t work!

a hint?

if i do it manual about the console and i use ' in values
it doesnt work too! if i use  it works !!!
any idea?

@Darin:
 Use the API function mysql_escape_string to prepare the value for
insertion.
how can i use it? for the complette string or only for the backslash
character?

thanks,
jörg



 hello there? :-)

 in which way can i handle backslashes in mysql++/vc?

 if i make a insert command like:

 Query  insert into blafasel values ('1', 'c:\mysql\test', '0');
 in c++

 i get no backslash in db!

 if i do it manual about the console it works and i have a
 backslash in the db!

 somebody any idea?

 thanks,
 jörg






 -
 Please check
http://www.mysql.com/Manual_chapter/manual_toc.html; before
posting. To request this thread, e-mail [EMAIL PROTECTED]

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail [EMAIL PROTECTED] instead.


-
Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before
posting. To request this thread, e-mail [EMAIL PROTECTED]

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail [EMAIL PROTECTED] instead.


-
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: Update

2002-04-25 Thread Richard Morton

Thanks for your input!

It is fixed now, by using the , instead of an and however, the thing that
threw me was that it didn't complain about it!

Thanks Again.

Richard


-Original Message-
From: Chris Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 5:10 PM
To: Salada, Duncan; 'Richard Morton'; MySQL List
Subject: Re: Update


I'd have to guess that MySQL is interpreting the set clause this way:

Set events_ID = ( 512 AND ( term = 'changed' ))

That is, a logical AND, so a zero result makes sense.  Still, it seems a bit
odd.


- Original Message -
From: Salada, Duncan [EMAIL PROTECTED]


For one of two reasons (probably) - and I think you found a bug:

1.  The syntax in your set clause is wrong.  It should be set
alternatepreference='C',AltContactID='1'  *Notice the use of a comma
instead of and*

2.  The row that matched the conditions in the where clause may already be
set to those values.  MySQL will not update a row needlessly.

I tried out your syntax on MySQL 3.23.47 (i.e. using and in the set
clause) and got some unexpected results.  Below is a synopsis of what
happened when I ran a query with the and syntax on my machine.

THE FIRST TIME
update events_terms set events_ID=512 and term='changed' where ID=108;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

It says a row was changed and it was -- but not correctly!  The events_ID
column was set to 0 and the term column was not changed at all.  That
doesn't seem like the correct behavior.  Then executed the query again...





-
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




Update

2002-04-23 Thread Richard Morton

mysql update contact set alternatepreference='C' and AltContactID='1' where
con
tactid=2;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0


any ideas why the UPDATE did not perform an update?

Thanks

Rich


-
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




versions

2002-04-22 Thread Richard Morton

Hi,

Has anybody heard how the next version of either MyODBC (3.51) or MySQL
(4.0.1) are coming along and when they will be declared stable?

I started developing with 4.0.1, and although I have had no failures to
date, I was said that they would be declared stable in dec/jan. it is now
several months later and my product is very close to some deployments.

It would be quite comforting to hear that they are in the stable tree.

Thanks

Rich


-
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: Mysqld as service

2002-04-10 Thread Richard Morton

mysqld --remove


use 

mysqld --help

for more info.




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 3:41 PM
To: MySQL-Mailingliste
Subject: Mysqld as service


Hi

How can i deinstall the mysqld as a service?
Thx for help

mfg

Ely Van Kenobi


-
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: NT service problem

2002-03-18 Thread Richard Morton

I am using MySQL4.02 as a service on W2Kpro.

You need to install the service before you can start it.

mysqld-nt --install

Then try the net start, possibly after a reboot.


Rich

-Original Message-
From: Tommy Claasens / QDC KZN [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 7:43 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: NT service problem


Hi,

What version of MySQL are you trying to get up and running ? If this version
is the mysql max, You will have to run the standalone first in order to
create the InnoDB datafiles, then it should start as a service.

I have had this exact same issue and it seemed to go away once I have run
the --standalone option.

Hope this helps
Tommy
-Original Message-
From: Alexander Hampel [mailto:[EMAIL PROTECTED]]
Sent: Mon, 18 Mar 2002 09:38
To: [EMAIL PROTECTED]
Subject: NT service problem


Hi Pierre,

Thanks, for your help.
That's what I exaclty do and this is for '--standalone' fine.
But the point ist, I want to start mysqld-nt as NT service -
and this is the problem - it wouldn't let me start it as service:
C:\net start mysql
System error 1069
Could not start service

The service is an important issue. Lets you run a programm under
different user rights.

Probably I'll find some other solution.

Thanks,
 A:lex



-Ursprüngliche Nachricht-
Von: Pierre du Parte [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 18. März 2002 08:04
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Betreff: Re: New to MySQL - can't start server :-(


Hi Alexander,
I use the PHPDEV compilation for local PHP/mySQL development work
(http://www.firepages.com.au/devindex.htm for a no-brainer approach to
getting PHP/mySQL/Apache up and running in seconds!)

Anyway, for me

start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone

kicks mySQL off on Win2K, NT and XP very nicely, thank you :)

If your mySQL is in c:\ then

start c:\mysql\bin\mysqld-nt.exe --standalone

should work

But I could be wrong, I often am


Pierre





Alexander Hampel wrote:

 Hi mailing list,

 I can't start mysqld-nt as I get the eror message 1067. If I start
 winmysqladmin.exe there is no server visible.

 The manual tell me in part 2.4 Post-installation Setup and Testing that I
 should start the script ./scripts/mysql_install_db but this script is not
 availabale (at all) at my Windows distribution.

 Any ideas what's wrong?


 Thank you,
  A:lex






 -
 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






--
Pierre du Parté
Final Filer Software
349 Worrigee Road
Worrigee, NSW, Australia 2540
http://www.finalfiler.com

Phone 61 2 44216374
Mobile 0413 483 066

If it feels good, do it!


-
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

-
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




4.0.1-max-nt - quick note

2002-02-12 Thread Richard Morton

I have installed the above as a service. The service seems to start ok, but
trying to run mysql console fails.

I am running this on Win2k Pro.

I have now reverted to MySQL4.0.1-NT running as a service and this works
fine.

Just a warning.

Richard


-
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: Selecting the row with largest number in a column

2002-01-27 Thread Richard Morton

Thanks, but using

SELECT MAX(age) FROM contacts

only gives me the maximum age, not the person with that age.

The table is tiny, changes very often and therefore indexes would be a waste
of time.

Thanks

Richard

-Original Message-
From: Butch Bean [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2002 20:04
To: DL Neil; Richard Morton; [EMAIL PROTECTED]
Subject: RE: Selecting the row with largest number in a column


The fastest way I found would be:

SELECT MAX(age) FROM contacts

good luck
bb

-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 26, 2002 12:14 PM
To: Richard Morton; [EMAIL PROTECTED]
Subject: Re: Selecting the row with largest number in a column


Hello Richard,


 I have a simple query, and a problem countless people must have had, I
just
 cannot work it out at the moment, I am new to MySQL; I hope you can help.

 My current statement looking at the manual.
 SELECT * FROM contacts WHERE age=MAX(age);

 I started with:
 mysql select * from contacts where age=(select MAX(age) from contacts);


 In escence I am trying to ascertain the details of the person who is
oldest.

 Any suggestions.?


Use the ORDER BY clause to show the table's records in inverted age order,
then require only the first row:

SELECT *
  FROM contacts
  ORDER BY age DESC
  LIMIT 1

Regards,
=dn



-
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




Selecting the row with largest number in a column

2002-01-25 Thread Richard Morton


Hello,

I have a simple query, and a problem countless people must have had, I just
cannot work it out at the moment, I am new to MySQL; I hope you can help.

My current statement looking at the manual.
SELECT * FROM contacts WHERE age=MAX(age);

I started with:
mysql select * from contacts where age=(select MAX(age) from contacts);


In escence I am trying to ascertain the details of the person who is oldest.

Any suggestions.?

Richard





-
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: Nested Queries.

2001-12-21 Thread Richard Morton

Hi,

In alot of cases you can use the following query structure (extract from
MySQL 4.0.0alpha manual)to negotiate the need for Sub-Selects.

I hope this helps.

-Rich





1.4.4.1 Sub-selects

MySQL currently only supports sub selects of the form INSERT ... SELECT ...
and REPLACE ... SELECT  You can however use the function IN() in other
contexts.

In many cases you can rewrite the query without a sub-select:

SELECT * FROM table1 WHERE id IN (SELECT id FROM table2);

This can be re-written as:

SELECT table1.* FROM table1,table2 WHERE table1.id=table2.id;

The queries:

SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2);
SELECT * FROM table1 WHERE NOT EXISTS (SELECT id FROM table2 where
table1.id=table2.id);

Can be rewritten as:

SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where
table2.id IS NULL

For more complicated subqueries you can often create temporary tables to
hold the subquery. In some cases, however this option will not work. The
most frequently encountered of these cases arises with DELETE statements,
for which standard SQL does not support joins (except in sub-selects). For
this situation there are two options available until subqueries are
supported by MySQL.

The first option is to use a procedural programming language (such as Perl
or PHP) to submit a SELECT query to obtain the primary keys for the records
to be deleted, and then use these values to construct the DELETE statement
(DELETE FROM ... WHERE ... IN (key1, key2, ...)).

The second option is to use interactive SQL to contruct a set of DELETE
statements automatically, using the MySQL extension CONCAT() (in lieu of the
standard || operator). For example:

SELECT CONCAT('DELETE FROM tab1 WHERE pkid = ', tab1.pkid, ';')
  FROM tab1, tab2
 WHERE tab1.col1 = tab2.col2;

You can place this query in a script file and redirect input from it to the
mysql command-line interpreter, piping its output back to a second instance
of the interpreter:

prompt mysql --skip-column-names mydb  myscript.sql | mysql mydb

MySQL 4.0 supports multi-table deletes that can be used to efficiently
delete rows based on information from one table or even from many tables at
the same time.


-Original Message-
From: Christian Andersson [mailto:[EMAIL PROTECTED]]
Sent: 20 December 2001 19:36
To: Larry Reiter; MySQL Mailing list
Subject: Re: Nested Queries.


Subqueries are not (yet)working in mysql, they will be implemented in the
4.0.x  or is it 4.x
which hopefully will be out very soon :-)

so if you are using the 3.23.xxx  you have to stick with temporary tables

/Christian

- Original Message -
From: Larry Reiter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 20, 2001 7:58 PM
Subject: Nested Queries.


 I have constructed a query which requires a temporary table but I
 would rather use a nested query.  In other words, I want to extract a
 set of data and then use that set of data as a query against some
 other data.  Like some sort of SELECT within a SELECT.  Can I do this
 in MySQL?

 Cheers,

 LTR
 --
 Dr. Lawrence T. Reiter
 Postdoctoral Fellow
 Department of Biology, UCSD
 Bonner Hall Room 4221
 9500 Gilman Drive
 La Jolla, CA   92093-0349

 Phone: (858) 534-0442
 FAX: (858) 822-2044
 http://homophila.sdsc.edu
 email: [EMAIL PROTECTED]

 -
 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


-
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