Re: Help with a JOIN query please
Hello shaun, May be with subselects you can do what you want: SELECT C.*,(select SUM(E.Amount) from Expenses E where E.Claim_ID = C.Claim_ID)AS Amount, (select SUM(M.Mileage) from Mileage M where M.Claim_ID = C.Claim_ID) AS Mileage FROM Claims C WHERE C.Claimant_ID = '1' st> Hi, st> I have ( among others ) three tables in my database: Claims, Expenses and st> Mileage. A claim can contain many expense entries and many mileage entries. st> I am using the follwing query to show the total expenses and mileage per st> claim for a particulare user: st> SELECT C.*, SUM(E.Amount) AS Amount, SUM(M.Mileage) AS Mileage st> FROM Claims C st> LEFT JOIN Expenses E ON E.Claim_ID = C.Claim_ID st> LEFT JOIN Mileage M ON M.Claim_ID = C.Claim_ID st> WHERE C.Claimant_ID = '1' st> GROUP BY C.Claim_ID st> The problem is if there are two mileage entries and one expense entry the st> expense total is doubled (and vice versa), can some explain this to me st> please? st> Thanks for your help. st> TABLE DEFINITIONS: mysql>> desc Claims; st> +-+-+--+-+-++ st> | Field | Type| Null | Key | Default | Extra | st> +-+-+--+-+-++ st> | Claim_ID| int(11) | | PRI | NULL| auto_increment | st> | Claimant_ID | int(11) | | | 0 | st> | Description | varchar(50) | | | | st> | Status | varchar(50) | YES | | Open| st> | Submission_Date | datetime| YES | | NULL| st> | Approval_Date | datetime| YES | | NULL| st> | Approver_ID | int(11) | YES | | NULL| st> +-+-+--+-+-++ st> 7 rows in set (0.00 sec) mysql>> desc Expenses; st> +-+---+--+-+-++ st> | Field | Type | Null | Key | Default | Extra st> | st> +-+---+--+-+-++ st> | Expense_ID | int(11) | | PRI | NULL| st> auto_increment | st> | Claim_ID| int(11) | YES | | NULL| st> | st> | Description | varchar(50) | YES | | NULL| st> | st> | Expense_Category_ID | int(11) | YES | | NULL| st> | st> | Insertion_Date | date | YES | | NULL| st> | st> | Project_ID | int(11) | YES | | NULL| st> | st> | Amount | decimal(10,2) | YES | | NULL| st> | st> | Rate_ID | int(11) | YES | | NULL| st> | st> | Supplier_ID | int(11) | YES | | NULL| st> | st> | Receipt | varchar(10) | YES | | NULL| st> | st> | Receipt_Date| varchar(10) | YES | | NULL| st> | st> | VAT_Receipt | varchar(10) | YES | | NULL| st> | st> | VAT_Amount | decimal(10,2) | YES | | NULL| st> | st> +-+---+--+-+-++ st> 13 rows in set (0.00 sec) mysql>> desc Mileage; st> ++--+--+-+++ st> | Field | Type | Null | Key | Default| Extra | st> ++--+--+-+++ st> | Mileage_ID | int(11) | | PRI | NULL | auto_increment | st> | Claim_ID | int(11) | | | 0 | st> | Project_ID | int(11) | | | 0 | st> | Insertion_Date | date | | | -00-00 | st> | Description| varchar(255) | | || st> | Start_Mileage | int(11) | | | 0 | st> | End_Mileage| int(11) | | | 0 | st> | Mileage| int(11) | | | 0 | st> ++--+--+-+++ st> 8 rows in set (0.00 sec) mysql>> -- Best regards, Krasimir_Slaveykov, 18 Ìàðò 2005 ã., 12:54:56 mailto: [EMAIL PROTECTED] [EMAIL PROTECTED] |-| |/ * * *** * ** /| | *** *** *** *** *** *** ** *** //| |/// *** *** * * *** **** *** ///| |// *** *** *** *** *** *** ** ****** | |/ *** *** *** * *** /| |--- www.office1.bg --| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [Q] INSERT INTO ... SELECT
Hello Riaan, RO> Is there a limit on the number of rows that can be RO> inserted in this way? Ie, at what point should I start RO> worrying about "out of memory" errors or something RO> similar? RO> So, how many rows can/should be returned by the SELECT clause? I had a similar case. Difference is that I tried to read result in the array and then to work from it. Hoever ... I think that the problem is in your RAM and OS. In my case I can read in memory succes up to 3 mil records. When I tried more I received Out Of Memory, too. I looked at windos swap file and it was more than 2GB Hoever, in my case I found desicion to read and insert data record by record. Slowly, but success. -- Best regards, Krasimir_Slaveykov, 03 Ôåâðóàðè 2004 ã., 15:49:27 mailto: [EMAIL PROTECTED] [EMAIL PROTECTED] |-| |/ * * *** * ** /| | *** *** *** *** *** *** ** *** //| |/// *** *** * * *** **** *** ///| |// *** *** *** *** *** *** ** ****** | |/ *** *** *** * *** /| |--- www.office1.bg --| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL and productivity
Hello , I must create a temp table with 5 or more million records. I need it for creating some reports, so I need to create indexes too. My question is: When total time for work will be smaller? : 1-st case: I create table and create indexes immediately before filling data. 2-nd case: I create table, filling data and then create indexes? -- Best regards, Krasimir_Slaveykov mailto: [EMAIL PROTECTED] [EMAIL PROTECTED] |-| |/ * * *** * ** /| | *** *** *** *** *** *** ** *** //| |/// *** *** * * *** **** *** ///| |// *** *** *** *** *** *** ** ****** | |/ *** *** *** * *** /| |--- www.office1.bg --| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to perform Inner Join
Hello Henry, Wednesday, July 16, 2003, 5:35:49 PM, you wrote: I've noticed 2 errors. First: You describe table with name: PUBLISHER but useing in SQL table PUBISHER - missing a letter "L" Second: As I'm understanding you want to make join table PUBLISHER with table TITLES. But see what you wrote in SQL: "FROM pubishers JOIN pubishers ON pubishers.pub_id = titles.pub_id" You trying to make join table with itself. H> I have 2 tables with the following fields : H> table : publisher H> field1: pub_id - Primary, int, auto H> table : titles H> field1: title_id - Primary, int, auto H> field1: pub_id - int H> Using sqlyog I noticed that the indexes had already been created for the H> Primary keys but according to my tutorial I also had to create an index for H> the foreign key. H> I did this and then tried to run the following query : H> SELECT pubishers.pub_id, titles.pub_ID H> FROM pubishers JOIN pubishers ON pubishers.pub_id = titles.pub_id H> It keeps giving me the following error : H> Error Code : 1066 H> Not unique table/alias: 'pubishers' H> Can someone tell me what I am doing wrong ? -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++359 2 97 66 701 Fax: ++359 2 97 66 731 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: auto number primary key - restarting
Hello Miroslav, Tuesday, July 15, 2003, 3:10:10 PM, you wrote: Easiest way to do what you want is to make this: 1.SHOW CREATE TABLE TableName and copy SQL 2. DROP TABLE TableName 3. CREATE TABLE - with SQL copied in 1. MI> Hi, MI> is there an SQL command for making a primary key (auto number key) to start numbering from beginning after deleting all the records from the table. MI> thanks -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: the number of Rows (records)
Hello Mojtaba, Monday, July 14, 2003, 3:57:42 PM, you wrote: If you want you can use /with Windows OS/ MySQL-Front to see some additionall information for tables and to use it for work area for some jobs. MF> Hi, MF> Is there any command or function in MySQL to find out how many records a MF> table has? phpMyAdmin shows the number of records ( Rows ) when shows the MF> structure of a table plus Row Length more information. How can we find these MF> table information? MF> Thanks -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: the number of Rows (records)
Hello Mojtaba, Monday, July 14, 2003, 3:57:42 PM, you wrote: try this: select count(*) from TableName MF> Hi, MF> Is there any command or function in MySQL to find out how many records a MF> table has? phpMyAdmin shows the number of records ( Rows ) when shows the MF> structure of a table plus Row Length more information. How can we find these MF> table information? MF> Thanks -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++359 2 97 66 701 Fax: ++359 2 97 66 731 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: How to copy records in one table?
Hello George, Monday, July 14, 2003, 11:46:06 AM, you wrote: Read this: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html GC> as far as i know, mysql version 4.0 and previous, do not support subqueries. GC> Select in select doesn't work. GC> Have a look in the manual if what u r trying to do is supported. GC> George Christoforakis. GC> PS: You don't mention your mysql version. Is this sql the exact command? GC> - Original Message - GC> From: "George Georgeus" <[EMAIL PROTECTED]> GC> To: <http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html> GC> Sent: Monday, July 14, 2003 10:54 AM GC> Subject: How to copy records in one table? >> Hi, >> >> does anybody know how to copy a record within one >> table? I am looking for some simple method similair to >> INSERT INTO orders SELECT * FROM orders WHERE >> Order_ID=256; Actually, this method does not work and >> I can not believe that MySQL does not offer some >> simple method how to do it. Keep in mind that I have a >> 60-field table. So, naming all fields is a pretty >> tedius task. >> >> Thaks Ge0rge >> >> >> Want to chat instantly with your online friends? Get the FREE Yahoo! >> Messenger http://uk.messenger.yahoo.com/ >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: GC> http://lists.mysql.com/[EMAIL PROTECTED] >> >> -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting all values between a max and a min value
Hello Shazia, Friday, July 11, 2003, 10:25:56 PM, you wrote: This is a tipical CROSSTAB QUERY. http://www.mysql.com/articles/wizard/print_version.html You also can use MS Access wich automatically suports crosstab query, to make this kind of report SF> Hi: SF> I have a table with one column as AppointmentID and for each AppointmentID I have multiple Payments. The table looks like this: SF> AppointmentIDPayment SF> 123 100 SF> 12350 SF> 123 200 SF> 124 30 SF> 124 100 SF> Now i want to write a MySql query which will retrieve all the payments corresponding to a particular AppointmentID .. the result should eb like this: SF> AppointmentID Payment1 Payment2 Payment3 Payment4 SF> 123 100 50200 0 SF> 12430 1000 0 SF> since the number of payments for each appointmnet vary, I calculate 4 payments(there are a max of 4 payments for an appointmentId) SF> I tried using Max and Min function but what about the rest which are in between the Max and Min. SF> Somebody help me out..i can't use subqury or union as i am using Mysql 3 -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LIMIT question
Hello Andrey, Friday, July 11, 2003, 7:28:27 PM, you wrote: http://www.mysql.com/doc/en/SELECT.html . The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments. The arguments must be integer constants. If two arguments are given, the first specifies the offset of the first row to return, the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1): To be compatible with PostgreSQL MySQL also supports the syntax: LIMIT # OFFSET #. ... A> Hello A> I have a following question: A> I have a table with thousands of rows which i need to show in a String Grid ( I use Borland Delphi with MyDac component which implements MySQL interface). A> If i make a query A> SELECT * FROM tbl WHERE col1="something", A> it can cause retreival of 10,000 records and my program will just eat all the Windows resources and die :) A> So i need to retreive first 1000 of rows, then on user's request, next 1000, etc. A> If i use SELECT ... LIMIT 1000, it just retreives first 1000 of records, which doesn't resolve my problem. A> Any ideas would be highly appreciated! A> Thank you, A> Andrey A> PS. Please respond to my email address directly, as i am not able to subscribe to the mailing list. A> - A> Do you Yahoo!? A> SBC Yahoo! DSL - Now only $29.95 per month! -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: grouping / sorting etc..
Hello Christopher, Friday, July 11, 2003, 6:31:33 PM, you wrote: First select: The results are just right what you want in your SELECT. You have 5 different values in COLUMN1 and your select returns them. >From second column SELECT gets first value for each value of first column. Second select: It works correct too. The data in yor excample are 9 records total. To have grouping you must have equal values in columns wich you incuded in group-criteria. You have only 2 records wich have the same values in grouping criteria...so they are grouped. The rest records are different. So it's normall second SQL to return 8 record. I don't know what is the main job anyway. But, if you want to exclude some records you can use WHERE clause for example. CK> Im having troubles getting the results I want... can someone suggest which way to go.. CK> mysql 4.0 CK> A CK> CK> | 1 | | CK> | 1 | BAD | CK> | 2 | | CK> | 3 | BAD | CK> | 3 | | CK> | 4 | BAD | CK> | 5 | | CK> | 5 | BAD | CK> | 5 | BAD | CK> CK> what I want is 5 results. If there is a NULL, then return the NULL, else return the BAD CK> so basically return ... CK> CK> | 1 | | CK> | 2 | | CK> | 3 | BAD | CK> | 4 | BAD | CK> | 5 | | CK> CK> Ive tried CK> select * from table group by 1stcolumn = (unpredicatble results, but returns 5 rows) The results are just right what you want in your SELECT. You have 5 different values in COLUMN1 and your select returns them. >From second column SELECT gets first value for each value of first column. CK> select * from talbe groub by 1stcolumn, 2ndcolumn = (returns 8 rows) CK> I could do the 2nd way then filter out w/ the code... CK> Is there a better way? CK> Thanks CK> Chris -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++359 2 97 66 701 Fax: ++359 2 97 66 731 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2 or more LEFT JOIN?
Hello mysql, If I have one main table - Tab1 and 2 or more tables wich are related with Tab1, but Tab2 possibly will have records for each in Tab1 ot possibly not. Tab3-too. So I need to join Tab1 with Tab2 with LEFT JOIN and Tab1 with Tab3 - with LEFT JOIN too. Is that possible? ... and if YES ... how to write in SQL statement? Thanks. -- Best regards, Krasimir_Slaveykov mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
constructing SQL problem
Hello , I have a problem with constructing correct SQL. I have tables: TABLE1 wich have FIELD1 and FIELD2 TABLE2 wich have FIELD1 and FIELD2 TABLE3 wich have FIELD1, FIELD2 and FIELD3 I have this SQL: select a.field1, a.field2, b.field2, c.field2 from TABLE1 as a, TABLE2 as b, TABLE3 as c where a.field1=b.field1 and a.field1=c.field1 and c.field3<>'string' My problem is that when C.FIELD3 is null i.e. in TABLE3 no record, these records are excluded from results. I needed them nevermind they have record in TABLE3 or not. Anyone help? -- Best regards, Krasimir_Slaveykov mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can mysql handle this load?
Hello Adam, Wednesday, July 09, 2003, 4:46:40 PM, you wrote: AG> I am writing an attendance system in php for my school. We have a AG> little less then 1000 students. For every day of the school year one AG> record will be entered into a table for each student representing their AG> attendance status (present, absent, late, etc...). I also have several AG> other supporting tables for relationships. When it comes to reporting AG> and querying this DB I am worried that it will very quickly become very AG> large and slow. Can mysql handle this? Are there any techniques to AG> speed it up? I will trying indexing major columns. AG> I have also considered keeping all previous days attendance in a AG> separate table from the current days attendance and moving things over AG> in the middle of the night. This way any operations on the current days AG> data will go quickly, but reports on long term things will still be AG> slow. Good idea? AG> Thanks, AG> Adam I think that you are worried for nothing. First of all your database seems to be small - less than half million records. The main think that you have to do is to organize your indexes correctly. I mean this: for good performance and high speed working of yor database you must have indexes on every field wich you will use in WHERE clauses or other conditions in your SQL's. AG> --- AG> Adam Gerson AG> Systems Administrator / Computer Teacher AG> Columbia Grammar and Prep School AG> 212-749-6200 AG> [EMAIL PROTECTED] AG> www.cgps.org -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 97 666 [EMAIL PROTECTED] Tel: ++359 2 97 66 701 Fax: ++359 2 97 66 731 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication / table copy question
Hello Kevin, Thursday, July 03, 2003, 12:28:38 AM, you wrote: For example you can do this: /with Perl/ Make connection to first database , then fill data from table source in array, then make connection to another database and fill data from array to another table. K> Hello, K> I have two mysql databases running on different hosts - the database are K> similiar in structure. I would like to copy specific tables from one db to K> another db on a scheduled basis. K> Is there a command to replicate a table from one db to another on a K> different host? K> TIA K> -roy -- Best regards, Krasimir_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: have a problem
Hello Stefan, Wednesday, April 02, 2003, 2:27:40 PM, you wrote: Here is table status: +---+++-++-+-+--+---+-+-+-+-++-+ | Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +---+++-++-+-+--+---+-+-+-+-++-+ | linii | MyISAM | Dynamic| 1194745 |130 | 155429332 | 4294967295 | 42998784 | 0 | 3472328119327703312 | 2003-04-02 10:48:27 | 2003-04-02 12:17:14 | 2003-04-02 10:50:26 || | +---+++-++-+-+--+---+-+-+-+-++-+ 1 row in set (0.00 sec) SH> Hello, >> When I execute this SQL: >> update table1 as a, table2 as b set a.field1=b.field1 >> where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 >> I received this error "execute failed: The table 'a' is full " >> What is the meaning of this? SH> This means that the table is full ;-) SH> You can find possible reasons for that here: SH> http://www.mysql.com/doc/en/Full_table.html SH> If you can't find a reason yourself, you might send the output of the SH> following statement to the list: mysql>> SHOW TABLE STATUS LIKE 'table1'; SH> This might help us find the reason for your problem. -- Best regards, PandaCoop-Krasimir_Slaveykovmailto:[EMAIL PROTECTED] Tel: ++359 2 942 75 94 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Interesting !?!
Hello mysql, We make updade of database from 3.23.49 to 4.0.12 Before update we can see host of connections /see Example1/. After update every connections looks like they made from local host /see Example2/, but they did not. Any explanation of effect?!? Example1: mysql> show processlist; +-+++---+-+--+---+--+ | Id | User | Host | db| Command | Time | State | Info | +-+++---+-+--+---+--+ | 1037596 | authengine | local.lozenec-sf.link.noc.sf.panda | squidauth | Sleep | 7081 | | NULL | | 1037597 | authengine | local.lozenec-sf.link.noc.sf.panda | squidauth | Sleep | 7081 | | NULL | | 1037622 | authengine | peer.hq.link.noc.sf.panda | squidauth | Sleep | 6751 | | NULL | | 1038112 | root | localhost | NULL | Query | 0 | NULL | show processlist | +-+++---+-+--+---+--+ 4 rows in set (0.00 sec) Your MySQL connection id is .. to server version: 3.23.49 Example2: mysql> show processlist; ++---++--+-+--+---+--+ | Id | User | Host | db | Command | Time | State | Info | ++---++--+-+--+---+--+ | 1 | pbxengine | localhost:2277 | pbx | Sleep | 66 | | NULL | | 2 | pbxengine | localhost:3188 | pbx | Sleep | 40 | | NULL | | 3 | pbxengine | localhost:1337 | pbx | Sleep | 213 | | NULL | | 11 | pbxengine | localhost:2833 | pbx | Sleep | 309 | | NULL | | 57 | root | localhost | NULL | Query | 0| NULL | show processlist | ++---++--+-+--+---+--+ 5 rows in set (0.01 sec) Your MySQL connection id is to server version: 4.0.12 -- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
have a problem
Hello mysql, When I execute this SQL: update table1 as a, table2 as b set a.field1=b.field1 where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 I received this error "execute failed: The table 'a' is full " What is the meaning of this? My server version: 4.0.12 -- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[EMAIL PROTECTED] Tel: ++359 2 942 75 94 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help about SQL sintax
Hello mysql, I have 2 tables : Table1: col1 col2 col3 DataSource Table2: col1 col2 col3 DataDestination How to update Table2.DataDestination with value of Table1.DataSourse where table1.col1=table2.col2 and table1.col2=table2.col2 and table1.col3=table2.col3 -- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[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