AW: Which Hardware do I need ?
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 ?
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
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 ?
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
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
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 !
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
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 version[10C3.23.41-log Protocol version[8C10 Connection[14CLocalhost via UNIX socket UNIX socket[13C/var/lib/mysql/mysql.sock Uptime:[17C7 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 [49;1HTS=64 -D_LARGEFILE_SOURCE' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_F [50;1HILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: lrwxrwxrwx1 root root[11C11 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 root[10C178 Jan 11 2001 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/u [57;1Hsr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --i ncludedir=/usr/include -- [58;1Hlibdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --shar edstatedir=/usr/com --man [59;1Hdir=/usr/share/man --infodir=/usr/share/info --without-debug --withou t-readline --enable-share[56;1H[1m[34m@ --- 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
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 version[10C3.23.41-log Protocol version[8C10 Connection[14CLocalhost via UNIX socket UNIX socket[13C/var/lib/mysql/mysql.sock Uptime:[17C7 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 [49;1HTS=64 -D_LARGEFILE_SOURCE' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_F [50;1HILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: lrwxrwxrwx1 root root[11C11 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 root[10C178 Jan 11 2001 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/u [57;1Hsr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --i ncludedir=/usr/include -- [58;1Hlibdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --shar edstatedir=/usr/com --man [59;1Hdir=/usr/share/man --infodir=/usr/share/info --without-debug --withou t-readline --enable-share[56;1H[1m[34m@ --- 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
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 version[10C3.23.41-log Protocol version[8C10 Connection[14CLocalhost via UNIX socket UNIX socket[13C/var/lib/mysql/mysql.sock Uptime:[17C7 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 [49;1HTS=64 -D_LARGEFILE_SOURCE' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_F [50;1HILE_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
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
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