AW: Which Hardware do I need ?

2002-02-06 Thread Daniel Backhausen

Hi.

Opens: ~4000 - 2
Queries p/s avg: 10 till 60

Thx for helping

Greetz
 Daniel



-Ursprüngliche Nachricht-
Von: Egor Egorov [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. Februar 2002 18:38
An: [EMAIL PROTECTED]
Betreff: Which Hardware do I need ?


Daniel,

Monday, February 04, 2002, 12:55:57 PM, you wrote:

DB Does somebody know which server hardware I have
DB to buy to realize my following problem ?

DB I have 3 tables. They are all connected to each other
DB with some queries.

DB 1st table has momentary 10.000 and should be upgraded to
DB 50.000 records.
DB 2nd table has 120.000 records at moment and should be
DB upgraded to 700.000 at time.
DB 3rd table has 200.000 records and should be upgraded to
DB 1.500.000 records.

DB Does somebody have experience with such a huge amount of
DB records in mySQL ?

DB We have momentary a DUAL 1 GHz Server with 1 GB Ram, but
DB he gets a load of 40 and restarts after some time.

Tell us about the number of connections open and number of
average simultaneous queries. Then we wil try to help.

DB  - Daniel Backhausen





--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [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




AW: Which Hardware do I need ?

2002-02-06 Thread Daniel Backhausen

Hi.

Our queries seem well optimized, maybe there are some slow queries
in there but sometimes you have no other choice and we are using indexes.
Our Key Buffer size is about 16MB (standard).

Thx for helping ...


Greetz
- Daniel



-Ursprungliche Nachricht-
Von: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. Februar 2002 23:53
An: Daniel Backhausen
Cc: mySQL Mailingliste
Betreff: Re: Which Hardware do I need ?


On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote:

  Hi.

  Does somebody know which server hardware I have to buy to realize my following 
problem
?

  I have 3 tables. They are all connected to each other with some queries.

  1st table has momentary 10.000 and should be upgraded to 50.000 records.
  2nd table has 120.000 records at moment and should be upgraded to 700.000 at time.
  3rd table has 200.000 records and should be upgraded to 1.500.000 records.

  Does somebody have experience with such a huge amount of records in
  mySQL ?

That's not huge. :-)

We've got one table with over 267 million rows in it and it grows
daily.

  We have momentary a DUAL 1 GHz Server with 1 GB Ram, but he gets a
  load of 40 and restarts after some time.

That should be more than sufficient.

Are your queries well optimized and using indexes?  How large is your
key buffer?

Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 0 days, processed 22,638,026 queries (388/sec. avg)


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

2002-02-06 Thread Daniel Backhausen

Hi.

No, Postgres has much more. The biggest point is, that it has
Subselects ! But mySQL seems to be much faster in some points.
That´s all I want to tell :)

Greetz
Daniel



-Original Message-
From: Vernon A Webb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 3:59 PM
To: MySQL
Subject: PostgreSQL


Hey All!

Anyone know the difference between MySQL and PostgreSQL?
Are the both pretty much the same? So far I like MySQL, but
find that MS SQL is far greater, but only because it has
much more. Anyone have any comments on the matter?



-
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




Which Hardware do I need ?

2002-02-04 Thread Daniel Backhausen


 Hi.

 Does somebody know which server hardware I have to buy to realize my following 
problem ?

 I have 3 tables. They are all connected to each other with some queries.

 1st table has momentary 10.000 and should be upgraded to 50.000 records.
 2nd table has 120.000 records at moment and should be upgraded to 700.000 at time.
 3rd table has 200.000 records and should be upgraded to 1.500.000 records.

 Does somebody have experience with such a huge amount of records in mySQL ?

 We have momentary a DUAL 1 GHz Server with 1 GB Ram, but he gets a load of 40 and
 restarts after some time.


 thx  regards
 - Daniel Backhausen


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

2002-01-07 Thread Daniel Backhausen

hi.

yes it is possible.

1. Create an new column which has an auto_increment option
2. Insert the first dataset manually as followed:

 INSERT INTO test (auto, char) VALUES ('100', 'Hello World!') 

3. From there on your auto column will count starting from 100, 101, 102,
...


Greeting
- Daniel Backhausen

---
N2MEDIA web-  multimediadesign
http://www.N2media.de - mailto:[EMAIL PROTECTED]



-Ursprüngliche Nachricht-
Von:
Gesendet: Montag, 7. Januar 2002 13:25
Betreff: auto_increment


Return-path: [EMAIL PROTECTED]
Envelope-to: [EMAIL PROTECTED]
Delivery-date: Mon, 07 Jan 2002 13:24:17 +0100
Received: from [192.58.197.162] (helo=web.mysql.com)
by mxng03.kundenserver.de with smtp (Exim 3.22 #2)
id 16NYp5-0002jj-00
for [EMAIL PROTECTED]; Mon, 07 Jan 2002 13:24:15 +0100
Received: (qmail 2142 invoked by uid 7797); 7 Jan 2002 12:17:41 -
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
List-ID: mysql.mysql.com
Precedence: bulk
List-Help: mailto:[EMAIL PROTECTED]
List-Unsubscribe:
mailto:[EMAIL PROTECTED]
List-Post: mailto:[EMAIL PROTECTED]
List-Subscribe: mailto:[EMAIL PROTECTED]
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 2128 invoked from network); 7 Jan 2002 12:17:40 -
Message-ID: 00f101c19776$4ca52130$0e64a8c0@mmehta
From: Manish Mehta [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Subject: auto_increment
Date: Mon, 7 Jan 2002 17:54:48 +0530
MIME-Version: 1.0
Content-Type: text/plain;
charset=x-user-defined
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-MDRemoteIP: 192.168.100.14
X-Return-Path: [EMAIL PROTECTED]
X-MDaemon-Deliver-To: [EMAIL PROTECTED]

Hi

Is it possible auto_increment start 100 instead of 1 .

for example

create table a
( a int(10) primary key auto_increment 100);

 Manish Mehta
E-mail: [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




AW: db and the web

2001-12-17 Thread Daniel Backhausen

Hi Frankie.

Where did you created a db ? Which data will you add to your
database ? A dump ? Be more specific.

Greetz
- Daniel Backhausen


---
N2MEDIA web-  multimediadesign
http://www.n2media.de - mailto:[EMAIL PROTECTED]



-Ursprüngliche Nachricht-
Von: Frankie Cooke [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 17. Dezember 2001 11:20
An: [EMAIL PROTECTED]
Betreff: db and the web


Hello all

I have created a database and now wish to make this available on the web,
does anyone know what I need to upload and how I go about this processs.  Is
it a normal ftp process etc

Please help  thanks for any help given

Frankie


-
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




AW: HELP... lot of Load !

2001-12-11 Thread Daniel Backhausen

Hello Benjamin.

Thanks a lot. Yes, you are right. It is a search engine. But I can?t get
rid of the OR expressions, cause it is implemented in the search formular
mask. So the User can choose any search criteria, which he wants. Neverthe-
less I will follow your hint and check out these queries manually to view
the load gage.

Greetz Daniel




-Ursprungliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Benjamin
Pflugmann
Gesendet: Dienstag, 11. Dezember 2001 22:04
An: Daniel Backhausen
Cc: mySQL Mailingliste
Betreff: Re: HELP... lot of Load !


Hi.

On Mon, Dec 10, 2001 at 02:06:41PM +0100, [EMAIL PROTECTED] wrote:
 ---
[...]
 # Time: 011210 13:40:23
 # User@Host: eff21[eff21] @ localhost []
 # Query_time: 25  Lock_time: 0  Rows_sent: 20  Rows_examined: 596309

 SELECT SQL_BIG_RESULT Locations.Location_ID, Locations.Neu,
 Locations.Sichtbar, Locations.Location_Name, Locations.PLZ, Locations.Ort,
 Locations.Strasse, COUNT(Termine.Location_ID) AS Count_Termine FROM
 Locations
 LEFT JOIN Termine
 ON Locations.Location_ID = Termine.Location_ID
 WHERE Locations.Kino != '1'
 AND (Locations.Location_Name LIKE '%%'
 OR Locations.Ort LIKE '%%'
 OR Locations.PLZ LIKE '%'
 OR Locations.Kategorien_Locations1_Name LIKE '%%'
 OR Locations.Kategorien_Locations2_Name LIKE '%%' )
 GROUP BY Locations.Location_ID
 ORDER BY Locations.Location_Name
 LIMIT 0,20
 ---

 Did this say anything to you advertently my high load ?
[...]

Not directly. But it is a *possible* reason.

To see if these queries are the reason, run such a query by hand and
watch the load (note that OS caching may influence the result for
subsequent runs) and the result of 'mysqladmin processlist'. If the
query is to blame, there should be a lot of LOCKED processes.

The query needed 25 seconds and had to scan a major part of the table
(596309 rows). MySQL is not good in optimizing OR expression. Note,
that the OR expressions above are redundant, as they will always
match. If you can get rid of them (I assume the query is build
automatically), the query will run faster.

Btw, one of the queries returned thousand of rows. Does that make
really sense (looks like a search engine to me). If not, don't allow
such queries, or use LIMIT shorten the search to a reasonable size.


Unfortunately you did not quote the result of EXPLAIN as I asked for,
so I cannot say more.

But simply start with what I have told and see how far you get.


Bye,

Benjamin.


--
[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




HELP... lot of Load

2001-12-10 Thread Daniel Backhausen

Hello.

When I start the mysql database my load is nearly zero. After some time
e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s
are going wild till 90% user 10% system. Normaly this system could handle
a lot of database operations.

Here are some system information:
- Dual Intel Pentium III 733
- 512 MB Ram
- RedHat Linux (Kernel 2.2.16)
- mySQL version 3.23.41.

I have created an output of my 'mysqlbug' status, so it might gonna help
solving the problem.

---
Server version3.23.41-log
Protocol version10
ConnectionLocalhost via UNIX socket
UNIX socket/var/lib/mysql/mysql.sock
Uptime:7 hours 33 min 15 sec

Threads: 64  Questions: 186759  Slow queries: 2799  Opens: 362  Flush
tables: 1
Open tables: 39;1H139 Queries per second avg: 6.867

Environment: 41;9Hmachine, os, target, libraries (multiple lines)
System: Linux 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.0)
Compilation info: CC='gcc'
 CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BI
TS=64 -D_LARGEFILE_SOURCE'  CXX='c++'
 CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_F
ILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root11 Feb 17  2001 /lib/libc.so.6 -
libc-2.2.so
-rwxr-xr-x1 root root  5155229 Jan 11  2001 /lib/libc-2.2.so
-rw-r--r--1 root root 24498288 Jan 11  2001 /usr/lib/libc.a
-rw-r--r--1 root root178 Jan 11  2001 /usr/lib/libc.so
Configure command: ./configure
 i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/u
sr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --i
ncludedir=/usr/include --
libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --shar
edstatedir=/usr/com --man
dir=/usr/share/man --infodir=/usr/share/info --without-debug --withou
t-readline --enable-share@


---
So if somebody has an idea, I will be really gratefully.

Regards.
- Daniel Backhausen


-
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




HELP .. lot of load

2001-12-10 Thread Daniel Backhausen

Hello.

When I start the mysql database my load is nearly zero. After some time
e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s
are going wild till 90% user 10% system. Normaly this system could handle
a lot of database operations.

Here are some system information:
- Dual Intel Pentium III 733
- 512 MB Ram
- RedHat Linux (Kernel 2.2.16)
- mySQL version 3.23.41.

I have created an output of my 'mysqlbug' status, so it might gonna help
solving the problem.

---
Server version3.23.41-log
Protocol version10
ConnectionLocalhost via UNIX socket
UNIX socket/var/lib/mysql/mysql.sock
Uptime:7 hours 33 min 15 sec

Threads: 64  Questions: 186759  Slow queries: 2799  Opens: 362  Flush
tables: 1
Open tables: 39;1H139 Queries per second avg: 6.867

Environment: 41;9Hmachine, os, target, libraries (multiple lines)
System: Linux 2.2.16-22smp #1 SMP Tue Aug 22 16:39:21 EDT 2000 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.0)
Compilation info: CC='gcc'
 CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BI
TS=64 -D_LARGEFILE_SOURCE'  CXX='c++'
 CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_F
ILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root11 Feb 17  2001 /lib/libc.so.6 -
libc-2.2.so
-rwxr-xr-x1 root root  5155229 Jan 11  2001 /lib/libc-2.2.so
-rw-r--r--1 root root 24498288 Jan 11  2001 /usr/lib/libc.a
-rw-r--r--1 root root178 Jan 11  2001 /usr/lib/libc.so
Configure command: ./configure
 i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/u
sr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --i
ncludedir=/usr/include --
libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --shar
edstatedir=/usr/com --man
dir=/usr/share/man --infodir=/usr/share/info --without-debug --withou
t-readline --enable-share@


---
So if somebody has an idea, I will be really gratefully.

Regards.
- Daniel Backhausen


-
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




AW: HELP... lot of Load

2001-12-10 Thread Daniel Backhausen

Hi Benjamin.

Thank you for your fast reply. I have another two small detailed questions.
1st: Do you think, if I compile the mysql source on my own it should be
better ?
I readed, that RedHat 7 has pre-compiled the mysql with an errorous version
of
gcc. ... so I would compile it on my own.
2nd: You said that I have to look these slow queries are. Can you explain it
a little bit ? I remember that joins can be very slow, and if there is an
mistake
in my query it can produce such a load ?

Regards
- Daniel Backhausen




Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Benjamin
Pflugmann
Gesendet: Montag, 10. Dezember 2001 11:28
An: Daniel Backhausen
Cc: [EMAIL PROTECTED]
Betreff: Re: HELP... lot of Load


Hi.

On Mon, Dec 10, 2001 at 11:06:24AM +0100, [EMAIL PROTECTED] wrote:
 Hello.

 When I start the mysql database my load is nearly zero. After some time
 e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s
 are going wild till 90% user 10% system. Normaly this system could handle
 a lot of database operations.

 Here are some system information:
 - Dual Intel Pentium III 733
 - 512 MB Ram
 - RedHat Linux (Kernel 2.2.16)
 - mySQL version 3.23.41.

 I have created an output of my 'mysqlbug' status, so it might gonna help
 solving the problem.
 --
--
 ---
 Server version3.23.41-log
 Protocol version10
 ConnectionLocalhost via UNIX socket
 UNIX socket/var/lib/mysql/mysql.sock
 Uptime:7 hours 33 min 15 sec

 Threads: 64  Questions: 186759  Slow queries: 2799  Opens: 362  Flush
 tables: 1

You should have a look what these slow queries are. With bad luck, one
bad query can queue up all others after it.

 Open tables: 39;1H139 Queries per second avg: 6.867
[...]
 GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
 gcc version 2.96 2731 (Red Hat Linux 7.0)
 Compilation info: CC='gcc'
  CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BI
 TS=64 -D_LARGEFILE_SOURCE'  CXX='c++'
  CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_F
 ILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  LDFLAGS=''
[...]

If that is the RH delivered binary (and to me it looks so), you may
want consider to use a pre-compiled binary from MySQL's website. There
are known issues with RH compiler and MySQL (and pre-compiled)
binaries - although I am not sure whether thy apply to your
environment. Btw, I doubt that this would be the source of your load
problems - I mentioned it just for completeness.

Bye,

Benjamin.



--
[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




AW: SELECT QUERY Problem

2001-12-10 Thread Daniel Backhausen

Hi. Try this one:

SELECT MAX(score) FROM scores_1, scores_2
WHERE Id = 15


Greetz
- Daniel Backhausen

-Ursprungliche Nachricht-
Von: Anatole [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 10. Dezember 2001 11:32
An: [EMAIL PROTECTED]
Betreff: SELECT QUERY Problem


Hello,

I often run into the problem of trying to join several tables and select
just the most recent (or largest) item from a series of entries.

For example.

Table 1: names
Id | name
15 | George
16 | Suzy

Table 2 : scores_1
Id | score
15 | 85
15 | 60
15 | 70
15 | 95

Table 3 : scores_2
Id | score
15 | 50
15 | 55
15 | 60
15 | 45

What I want to end up with is a selection that would pick up George and his
highest score on score_1 and score_2 (i.e. George 95 60)

Anybody have a pretty way to do this???

Thanks for any advice you can throw my way!

anatole


-
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




AW: is type casting available

2001-12-10 Thread Daniel Backhausen

Hi. Best and simpliest way ist to use phpMyAdmin for
such changes.

Greetz
- Daniel Backhausen


-Ursprüngliche Nachricht-
Von: sreedhar [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 10. Dezember 2001 12:43
An: mysql
Betreff: is type casting available


hi all,

how can i cast a variable either from integer to varchar or varchar to
integer in mysql.

thanks in advance.

regards,
sreedhar


-
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