RE: Problems with mysql_fetch_row()
Hi there. I've been having this problem when retrieving rows from a table using mysql_fetch_row(). The problem is that sometimes it returns null when I know that there are more records available. The behaviour is intermittent too so its really difficult to track down. I've tried it with MySQL Version 4.1.4 and also 4.1.12 and I get the same behaviour (on Suse Linux, i386 architecture). The select statement is as follows: SELECT raw_id,forename,surname,addr1,addr2,addr3,addr4,addr5,addr6,postal_area, dob,email FROM `ssain` WHERE (matched IS NULL); However, looping through mysql_fetch_row() - after mysql_use_result() - with: while((MySqlRow = mysql_fetch_row(MySqlResult)) != NULL) The while loop intermittently terminates early. When the loop does terminate early, it is usually (but not always) after it has correctly processed record number 664, but I dont know if this is of any significance. if I run: SELECT count(*) FROM ssain WHERE (matched IS NULL); then I get 2027085 (just over 2 million) so I know that it should be able to pull the records themselves. When the mysql_fetch_row() loop does break out early, the next time the database handle is used (for another SQL statement), the following error is reported: Error 2006 (MySQL server has gone away) and I also get this message when I check mysql_error() with: if(strcmp(mysql_error(MySqlConn),)!=0) I've turned on as many logging options on the server as I can find but no errors are reported. I've also looked on various places on the internet to any possible solutions, all to no avail. All references to MySQL server has gone away on google mention various time-out settings, however I get the issue after a few minutes in total, and the statement handle is in use any way so there is no time for a time-out to occur? I'm really at the last of my tethers with this one so any help or suggestions will be gratefully received. Many thanks in advance!! Bradley Kite Software Developer/Data Management Specialist alchemetrics - smarter data, faster Tel: 0118 902 9043 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Filling database with load data
Hallo Peter, Op 30 May 05 schreef Peter aan [EMAIL PROTECTED]: P http://dev.mysql.com/doc/mysql/en/load-data-local.html P # P If LOAD DATA LOCAL INFILE is disabled, either in the server or the P client, a client that attempts to issue such a statement receives the P following error message: P ERROR 1148: The used command is not allowed with this MySQL version P I hope this help. I sure does, thank you very much. And that information was even in the tutorial part of the manual. I'm ashamed of myself :( Groetjes, Hans. --- GoldED+/LNX 1.1.5/040412 * Origin: The Wizard is using MBSE/Linux (2:280/1018) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GROUP BY ORDER BY
I'm trying to SELECT the most recent record in a table for each person record in another table. Here's what I have so far: SELECT history.*, persons.person_short_name, persons.person_long_name FROM history, persons WHERE persons.id = history.person_id AND persons.status = 1 GROUP BY history.person_id ORDER BY history.time_sec DESC The good thing: It retrieves DISTINCT persons (no duplicates). The problem: The history rows are not the most recent for each person. What I would need, theoretically, is for the ORDER BY clause to go before GROUP BY, but MYSQL doesn't like that it seems. Any ideas? Thanks. ...René --- René Fournier www.renefournier.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Something boring about mysql application!!!
Hi, mysql -S /opt/usr/mysql4/var/mysql.socket -uusr -p11 is 11 your database, i don't think so. That should dbe the password. so, the command to connect that can be found in the doc can be : mysql -uusr -p mysql this will prompt you tu enter the password Password: here type 11 and you are connected. look at the doc at mysql.com Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem loading dates from txt file
Hello list! Im loading rows from a txt tab separated fields file into a MySQL table. It mostly works, but the date format in one field is not the type that MySQL likes. So right now Im loading it as a char field. Yes, it is ugly and a pain to work with. I would like to some how automate it and change the time format. From - 30-May-05 To - 2005-05-30 The txt file is initially generated from an excel sheet. Im using: MySQL 4.1.11 on Red Hat 9 with kernel 2.4.20 Any ideas? James Collado
Re: Cannot start mysql due to possibly a bug
Hello. Are you sure that mysqld uses /etc/mysql/my.cnf? See: http://dev.mysql.com/doc/mysql/en/option-files.html I suggest you to use official binaries and perform installation according to the following: http://dev.mysql.com/doc/mysql/en/installing-binary.html Mouse Doctor X [EMAIL PROTECTED] wrote: Nice time of the day. I apologize I am writing on this address because didn't find START NEW THREAD on mailing lists page. The problem is this: I have the freshest version of Gentoo Linux, and mysql within it. Just didn't modify /etc/mysql/my.cnf, commenting only one line: skip-innodb. Have read about first mysql startup, and launched mysql_install_db as root. All went ok. Then, /etc/init.d/mysql start, started ok. When giving first command: /usr/bin/mysqladmin -u root -h my_host password 'new-password', it sends me somewhere saying: /usr/bin/mysqladmin: connect to server at 'my_host' failed error: 'Lost connection to MySQL server during query' When inspecting /var/log/mysql/mysqld.err log file, find there that /var/mysql.frm is not found. ... out of comment. Also, when stopping mysql, it refuses to be stopped. Help! Thanks in advance -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication problem
Hello. Not enough information to make a conclusion. What version of MySQL do you use? Usually debugging of replication problems begins from researching of binary logs with mysqlbinlog. See: http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html http://dev.mysql.com/doc/mysql/en/slave-logs.html http://dev.mysql.com/doc/mysql/en/binary-log.html Please, next time include the output of SHOW SLAVE STATUS (executed on the slave) and SHOW MASTER STATUS (executed on the master) as well. Weicheng Pan [EMAIL PROTECTED] wrote: Hi all: I have replication problem on my FreeBSD 5.4 AMD64 box. Sometimes replication will stop and throw an error code 1054, but the query is not the original one in the master. A query like UPDATE table_a SET col_a = 'abc' where col_b = 234 the right most character will become a strange character, and cannot print out in error log. I have twelve machines doing the replication work, but only got problem on this AMD64 machine. Anyone has encounter this type problem? please give me some advise. Thanks and have a nice day. Regards, Weicheng. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query problem
Hello. You should solve the issue with server crashes. I'm not familiar with JDBC, and if changing the values of parameters with SET statement doesn't work with JDBC, probably somebody clever on the list could help you. You may forward your message to: http://lists.mysql.com/java Yes the server dies during the queries from JDBC. Regarding the client parameters, what if the client doesn't have mySQL installed? Amir Amir Shay [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Something boring about mysql application!!!
Hello. See: http://dev.mysql.com/doc/mysql/en/access-denied.html http://dev.mysql.com/doc/mysql/en/resetting-permissions.html Hi,all I have installed a Mysql4 verion on Turbo Linux successfully recently.But I alwaysgot the error prompt from the database when I did the connect to this DB. Details: [EMAIL PROTECTED] bin]$ mysqlshow mysqlshow: Can't connect to local MySQL server through socket '/opt/usr/mysql4/data/temp.sock' (2) [EMAIL PROTECTED] bin]$ mysql -S /opt/usr/mysql4/var/mysql.socket ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED] bin]$ mysql -S /opt/usr/mysql4/var/mysql.socket -uroot ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED] bin]$ mysql -S /opt/usr/mysql4/var/mysql.socket -uusr ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED] bin]$ mysql -S /opt/usr/mysql4/var/mysql.socket -uusr -p11 ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) song wang [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GROUP BY ORDER BY
GROUP BY returns grouped columns and aggregate functions, not rows. You are grouping on history.person_id, so it makes no sense to select any column that does not have a unique value for each history.person_id. Indeed, other systems wouldn't even allow selecting non-grouped columns http://dev.mysql.com/doc/mysql/en/group-by-hidden-fields.html. Hence your problem. You want to select the rows where the history.time_sec is the most recent (MAX) per group. That's essentially a 2-step process: first find the max history.time_sec for each group, then select the rows which match. You can either save the result of the first step in a temporary table to use in the second step, or, if you have at least 4.1, you can use a subquery to write it as one statement. The manual has examples, as well as a 3rd, inefficient, 1-step method http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html. Michael René Fournier wrote: I'm trying to SELECT the most recent record in a table for each person record in another table. Here's what I have so far: SELECT history.*, persons.person_short_name, persons.person_long_name FROM history, persons WHERE persons.id = history.person_id AND persons.status = 1 GROUP BY history.person_id ORDER BY history.time_sec DESC The good thing: It retrieves DISTINCT persons (no duplicates). The problem: The history rows are not the most recent for each person. What I would need, theoretically, is for the ORDER BY clause to go before GROUP BY, but MYSQL doesn't like that it seems. Any ideas? Thanks. ...René --- René Fournier www.renefournier.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to get the name of the last failed FK constraint
Hello, I have an InnoDB table running on MySQL 4.1.11 with multiple FK constraints. I'm accessing it via JDBC from Java. When an FK constraint fails with error 1216 I need to know which of the constraints failed. SHOW INNODB STATUS returns the following output ... CONSTRAINT `u_registration_ibfk_1` FOREIGN KEY (`DEVICE_ID`) REFERENCES `u_device` (`DEVICE_ID`) ... Is there a way of getting to the name of the last failed FK constraint without using SHOW INNODB STATUS? What I need is the 'u_registration_ibfk_1' from the above example. Any help is highly appreciated -- Frank -- 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]
email notification
I'm looking for a feature in mysql where it will email me if ther are any changes in a particular database or table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with mysql_fetch_row()
Hello. You may debug your client. See: http://dev.mysql.com/doc/mysql/en/debugging-client.html Have you been at: http://dev.mysql.com/doc/mysql/en/gone-away.html Increase your packet size. See: http://dev.mysql.com/doc/mysql/en/packet-too-large.html Bradley Kite [EMAIL PROTECTED] wrote: Hi there. I've been having this problem when retrieving rows from a table using mysql_fetch_row(). The problem is that sometimes it returns null when I know that there are more records available. The behaviour is intermittent too so its really difficult to track down. I've tried it with MySQL Version 4.1.4 and also 4.1.12 and I get the same behaviour (on Suse Linux, i386 architecture). The select statement is as follows: SELECT raw_id,forename,surname,addr1,addr2,addr3,addr4,addr5,addr6,postal_area, dob,email FROM `ssain` WHERE (matched IS NULL); However, looping through mysql_fetch_row() - after mysql_use_result() - with: while((MySqlRow = mysql_fetch_row(MySqlResult)) != NULL) The while loop intermittently terminates early. When the loop does terminate early, it is usually (but not always) after it has correctly processed record number 664, but I dont know if this is of any significance. if I run: SELECT count(*) FROM ssain WHERE (matched IS NULL); then I get 2027085 (just over 2 million) so I know that it should be able to pull the records themselves. When the mysql_fetch_row() loop does break out early, the next time the database handle is used (for another SQL statement), the following error is reported: Error 2006 (MySQL server has gone away) and I also get this message when I check mysql_error() with: if(strcmp(mysql_error(MySqlConn),)!=0) I've turned on as many logging options on the server as I can find but no errors are reported. I've also looked on various places on the internet to any possible solutions, all to no avail. All references to MySQL server has gone away on google mention various time-out settings, however I get the issue after a few minutes in total, and the statement handle is in use any way so there is no time for a time-out to occur? I'm really at the last of my tethers with this one so any help or suggestions will be gratefully received. Many thanks in advance!! Bradley Kite Software Developer/Data Management Specialist alchemetrics - smarter data, faster Tel: 0118 902 9043 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ** -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb optimzation
Hi stephano, Just read the last comment at this link http://dev.mysql.com/doc/mysql/en/optimize-table.html and you will have positive answers to your questions. Mathias Selon [EMAIL PROTECTED]: Hi all, I have an Innodb database (MySQL 4.0.21 on Linux). The db is made of 11 tables. 10 of these tables are just a few MBs altogether, while the 11th table, due to a longtext field where binary data is stored, is about 3GBs and counting (about 80MBs inserted everyday). Since Innodb doesn't seem to reuse disk space efficiently, a day will come when I will have to rebuild the table, both to improve performance and to reclaim disk space. Altering to MyISAM and back is an option I'd rather not choose because it would take a lot to perform 2 conversions, and laso I'd need to recreate foreign constraints, and to have more disk space. Heikki's advice of running: ALTER TABLE tablename TYPE=Innodb sounds good, but there's a couple of issues I haven't found an answer to: 1) I suppose the above statement rebuilds the table from scratch. The new table will be created starting from the 1st free data page in the tablespace, is this correct? In this case I'll need to issue the ALTER TABLE command before the table's data length = 0.5 * available disk space, is this correct? 2) Once I have rebuilt the table, assuming the above is true, will the space formerly occupied by the old table be entirely returned to the free pool, i.e. added to innodb free? This is important because though the new table would be optimized, I'd have a huge space waste if the answer to this questio is no. Thanks for any input Stefano -- 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: Fw: Inner workings of a JOIN
Thank you for all of your answers and suggestions. I feel a lot more confident finishing my table designs -James
Re: problem loading dates from txt file
At 05:23 AM 5/31/05, James M. Gonzalez wrote: Im loading rows from a txt tab separated fields file into a MySQL table. It mostly works, but the date format in one field is not the type that MySQL likes. So right now Im loading it as a char field. Yes, it is ugly and a pain to work with. I would like to some how automate it and change the time format. From - 30-May-05 To - 2005-05-30 The txt file is initially generated from an excel sheet. Im using: MySQL 4.1.11 on Red Hat 9 with kernel 2.4.20 Any ideas? Change the format of column in Excel before exporting the data. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database design query
Hi All, I'm trying to get data from Active Directory and storing in database. So I have the following tables with their corresponding primary keys: Group (GroupID) Host (HostID) User (UserID) GroupMember(GroupID, MemberID) The relations between them according to Active Directory should be as follows: 1) Host and user can be in one or more groups 2) Groups can be in one or more groups I was trying to implement these relations through Db constraints. I wanted HostID and UserID should refer to MemberID as Primary Key. My problems is a foreign key field cannot refer to a part of primary key, so 1) I should add GroupID in Host and User table, which will be redundancy of data, or 2) Instead of adding a new field, I should not have any relations in the database and just implement it in code. I have tried with three different designs, but all of them have some issues. I tied to add a new table just for Member that would store unique memberID. Does it seem like an overhead? I don't if I can just do with existing table or not. I read some articles online, some of them say it's good to implement relations from DB and some say to reduce overhead, relations can be implemented from code. What would the best database practice that you would suggest? I'll appreciate any help Thanks, Reema Duggal Troiana Senior Software Developer BitArmor Systems, Inc. 357 North Craig Street Ground Floor Pittsburgh, PA 15213 [TEL] 412-682-2200 Ext 314 [FAX] 412-682-2201
RE: email notification
I doubt you would find this feature in any database. You would have to implement at the application code level. Basically whenever you insert into a table have the application framework send an e-mail. The log4j package provides this kind of functionality. See http://logging.apache.org/ And look for information on the SMTP appender. Cheers, Philip. -Original Message- From: Jayson [mailto:[EMAIL PROTECTED] Sent: May 31, 2005 6:59 AM To: mysql@lists.mysql.com Subject: email notification I'm looking for a feature in mysql where it will email me if ther are any changes in a particular database or table. -- 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: problem loading dates from txt file
If the data is on a spreadsheet, then why not use excel to rewrite the date? For example, copy the text where the dates are,...then format the entire column to be text and not a date (because excel stores dates as numbers,...but displays them as dates),...then paste the dates back into the column,...now using some other columns, you can create the format you want,... use this in a cell and it'll pull the 3 characters out that are the Month (ie Jan, Feb, Mar, etc) =mid(A1,4,3) use this (extend it to December) in another cell to translate the month into the numbers,... =IF(B1=Jan,01,IF(B1=Feb,02,IF(B1=Mar,03,IF (B1=Apr,04,IF(B1=May,05) Do something similar to translate your year into a 4 digit (or before reformatting the original data, have excel display it with a 4 digit year, then copy it, reformat to text, and paste it back). Then you can pull them all together in another cell,... =C1 - D1 - right(A1,2) Look at the functions left, right, mid to see how to pull out parts,... Jeff * Jeff Mao Coodinator of Educational Technology Maine Department of Education 23 State House Station Augusta, ME 04333 (207) 624-6634 (office) (207) 462-4137 (mobile) [EMAIL PROTECTED] On May 31, 2005, at 5:23 AM, James M. Gonzalez wrote: Hello list! Im loading rows from a txt tab separated fields file into a MySQL table. It mostly works, but the date format in one field is not the type that MySQL likes. So right now Im loading it as a char field. Yes, it is ugly and a pain to work with. I would like to some how automate it and change the time format. From - 30-May-05 To - 2005-05-30 The txt file is initially generated from an excel sheet. Im using: MySQL 4.1.11 on Red Hat 9 with kernel 2.4.20 Any ideas? James Collado -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Call a function from a select statement?
Is this not the proper way to use a function in a select statement? SELECT t.field1, t.field2, functionPerformAdditionalQueryFromField(t.field2) AS 'customField' FROM Table t I'd like to perform the function on every row in the result set, and store the returned value of that function in EACH row, as a custom field. It works from the command line, but in PHP... the result set comes back the FIRST time, but then I lose my connection to the database, and need to restart the service in 2003 server. Very frusterating...any help is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
deleting user variable
Hi, A simple question. How to delete the user variables created on the server using set @varname=expr syntax? thanks, Samit __ Discover Yahoo! Stay in touch with email, IM, photo sharing and more. Check it out! http://discover.yahoo.com/stayintouch.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Call a function from a select statement?
Are you getting a error Lost Connection to Server error? If you are reconnect to the server every time you issue the SQL request. OR issue the command set GLOBAL wait_timeout=28000; Then issue the select DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: Scott Klarenbach [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 10:58 AM To: My SQL Subject: Call a function from a select statement? Is this not the proper way to use a function in a select statement? SELECT t.field1, t.field2, functionPerformAdditionalQueryFromField(t.field2) AS 'customField' FROM Table t I'd like to perform the function on every row in the result set, and store the returned value of that function in EACH row, as a custom field. It works from the command line, but in PHP... the result set comes back the FIRST time, but then I lose my connection to the database, and need to restart the service in 2003 server. Very frusterating...any help is appreciated. -- 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: email notification
If we get triggers in mysql 5, couldn't you setup something like this? --ja On Tue, 31 May 2005, Philip Denno wrote: I doubt you would find this feature in any database. You would have to implement at the application code level. Basically whenever you insert into a table have the application framework send an e-mail. The log4j package provides this kind of functionality. See http://logging.apache.org/ And look for information on the SMTP appender. Cheers, Philip. -Original Message- From: Jayson [mailto:[EMAIL PROTECTED] Sent: May 31, 2005 6:59 AM To: mysql@lists.mysql.com Subject: email notification I'm looking for a feature in mysql where it will email me if ther are any changes in a particular database or table. -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: email notification
I don't think there is an SMTP API built into MySQL. A trigger could insert a record into another table and a crontab could send mails based on the contents of this table.. On 5/31/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: If we get triggers in mysql 5, couldn't you setup something like this? --ja On Tue, 31 May 2005, Philip Denno wrote: I doubt you would find this feature in any database. You would have to implement at the application code level. Basically whenever you insert into a table have the application framework send an e-mail. The log4j package provides this kind of functionality. See http://logging.apache.org/ And look for information on the SMTP appender. Cheers, Philip. -Original Message- From: Jayson [mailto:[EMAIL PROTECTED] Sent: May 31, 2005 6:59 AM To: mysql@lists.mysql.com Subject: email notification I'm looking for a feature in mysql where it will email me if ther are any changes in a particular database or table. -- -- 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: email notification
Jayson, Are you working with Windows or UNIX versions of MySQL? Mikhail Berman -Original Message- From: Jayson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 9:59 AM To: mysql@lists.mysql.com Subject: email notification I'm looking for a feature in mysql where it will email me if ther are any changes in a particular database or table. -- 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: Call a function from a select statement?
Tried that, but to no avail. I'm running Mysql 5.0.4 and PHP 5.0.4, and was hoping it is a bug in one of these, but I don't think so... I can run the query as I said from the command line, but in PHP, I get a real_connect_error, immediately after executing the query... that is...the windows service shuts down at the completion of the query and needs to be manually restarted...(the service crashing, is what causes the real_connect_error)... On 5/31/05, Dathan Pattishall [EMAIL PROTECTED] wrote: Are you getting a error Lost Connection to Server error? If you are reconnect to the server every time you issue the SQL request. OR issue the command set GLOBAL wait_timeout=28000; Then issue the select DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: Scott Klarenbach [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 10:58 AM To: My SQL Subject: Call a function from a select statement? Is this not the proper way to use a function in a select statement? SELECT t.field1, t.field2, functionPerformAdditionalQueryFromField(t.field2) AS 'customField' FROM Table t I'd like to perform the function on every row in the result set, and store the returned value of that function in EACH row, as a custom field. It works from the command line, but in PHP... the result set comes back the FIRST time, but then I lose my connection to the database, and need to restart the service in 2003 server. Very frusterating...any help is appreciated. -- 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: deleting user variable
Hi Samit, mysql select @toto - ; +---+ | @toto | +---+ | NULL | +---+ 1 row in set (0.00 sec) mysql set @toto:=5; Query OK, 0 rows affected (0.01 sec) ... use @toto ... mysql set @toto:=NULL; Query OK, 0 rows affected (0.00 sec) mysql select @toto; +---+ | @toto | +---+ | NULL | +---+ 1 row in set (0.00 sec) Selon samit jain [EMAIL PROTECTED]: Hi, A simple question. How to delete the user variables created on the server using set @varname=expr syntax? thanks, Samit __ Discover Yahoo! Stay in touch with email, IM, photo sharing and more. Check it out! http://discover.yahoo.com/stayintouch.html -- 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: Database design query
Hi, i think you must normalize your table to more than one table. Users/Groups : N:1 Groups/Groups : N:1 Table Users : User_id Host Group_id Table Groups : Group_id Group_parent_id- is a another group_id No data redondancy and robust implementation. see for example /etc/passwd and /etc/group on a *nix machine. Mathias Selon rtroiana [EMAIL PROTECTED]: Hi All, I'm trying to get data from Active Directory and storing in database. So I have the following tables with their corresponding primary keys: Group (GroupID) Host (HostID) User (UserID) GroupMember(GroupID, MemberID) The relations between them according to Active Directory should be as follows: 1) Host and user can be in one or more groups 2) Groups can be in one or more groups I was trying to implement these relations through Db constraints. I wanted HostID and UserID should refer to MemberID as Primary Key. My problems is a foreign key field cannot refer to a part of primary key, so 1) I should add GroupID in Host and User table, which will be redundancy of data, or 2) Instead of adding a new field, I should not have any relations in the database and just implement it in code. I have tried with three different designs, but all of them have some issues. I tied to add a new table just for Member that would store unique memberID. Does it seem like an overhead? I don't if I can just do with existing table or not. I read some articles online, some of them say it's good to implement relations from DB and some say to reduce overhead, relations can be implemented from code. What would the best database practice that you would suggest? I'll appreciate any help Thanks, Reema Duggal Troiana Senior Software Developer BitArmor Systems, Inc. 357 North Craig Street Ground Floor Pittsburgh, PA 15213 [TEL] 412-682-2200 Ext 314 [FAX] 412-682-2201 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Database design query
IF GroupID, HostID and UserID are unique between the three sets then your GroupMember table will work although I would still be tempted to add a MemberType in the GroupMember table. Isn't MemberID the Foreign Key to UserID/HostID/GroupID althugh I don't know if you can have three different foreign key definitions on one field. If not I think you are stuck with 3 tables instead of trying to do it in one. -Original Message- From: rtroiana [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 12:23 PM To: mysql@lists.mysql.com Subject: Database design query Hi All, I'm trying to get data from Active Directory and storing in database. So I have the following tables with their corresponding primary keys: Group (GroupID) Host (HostID) User (UserID) GroupMember(GroupID, MemberID) The relations between them according to Active Directory should be as follows: 1) Host and user can be in one or more groups 2) Groups can be in one or more groups I was trying to implement these relations through Db constraints. I wanted HostID and UserID should refer to MemberID as Primary Key. My problems is a foreign key field cannot refer to a part of primary key, so 1) I should add GroupID in Host and User table, which will be redundancy of data, or 2) Instead of adding a new field, I should not have any relations in the database and just implement it in code. I have tried with three different designs, but all of them have some issues. I tied to add a new table just for Member that would store unique memberID. Does it seem like an overhead? I don't if I can just do with existing table or not. I read some articles online, some of them say it's good to implement relations from DB and some say to reduce overhead, relations can be implemented from code. What would the best database practice that you would suggest? I'll appreciate any help Thanks, Reema Duggal Troiana Senior Software Developer BitArmor Systems, Inc. 357 North Craig Street Ground Floor Pittsburgh, PA 15213 [TEL] 412-682-2200 Ext 314 [FAX] 412-682-2201 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql shutsdown immediately after password input
I have never got mysql to start because each time I input my password, the window closes (I am using Windows XP). The error is something like: ERROR 2013: Lost connection to mysql server during query. How do I resolve this? -M.B. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do you become a MySQL DBA
Here's an odd question for you, how do you become a MySQL DBA? I've got enough Solaris/Linux Experience under my belt and I was a Jr. Oracle DBA for a year, which got me really interested in RDBMS. I try to work with MySQL as much as possible, but I work with one of those large telco's that does not like anything where they can't pay large amounts of money. This means I have to work it into my spare time. I've been trying to tie MySQL into basic services: ftp, DSPAM, pop3, AND offer help for what we do have: running backups and repairing the odd table when needed. But the question is, what else could I do to help develope DBA skills? Right now I have very little data that goes beyond 2 tables, so my query skills are withering. mediis a t gmail d o t com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.0.6-beta has been released
Hi, A new version of MySQL Community Edition 5.0.6-beta Open Source database management system has been released. This version includes support for Stored Procedures, Triggers, Views and many other features. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up-to-date at this point. If you cannot find this version on a particular mirror, please try again later or choose another download site. This is the third published Beta release in the 5.0 series. All attention will now be focused on fixing bugs and stabilizing 5.0 for later production release. NOTE: This Beta release, as any other pre-production release, should not be installed on ``production'' level systems or systems with critical data. It is good practice to back up your data before installing any new version of software. Although MySQL has done its best to ensure a high level of quality, protect your data by making a backup as you would for any software beta release. Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual open and resolved bugs in this version. Changes in release 5.0.6: Functionality added or changed: * INCOMPATIBLE CHANGE: `MyISAM' and `InnoDB' tables created with `DECIMAL' columns in MySQL 5.0.3 to 5.0.5 will appear corrupt after an upgrade to MySQL 5.0.6. Dump such tables with `mysqldump' before upgrading, and then reload them after upgrading. (The same incompatibility will occur for these tables created in MySQL 5.0.6 after a downgrade to MySQL 5.0.3 to 5.0.5.) (Bug #10465, Bug #10625) * Added `REFERENCED_TABLE_SCHEMA', `REFERENCED_TABLE_NAME', and `REFERENCED_COLUMN_NAME' columns to the `KEY_COLUMN_USAGE' table of `INFORMATION_SCHEMA'. (Bug #9587) * Added a `--show-warnings' option to `mysql' to cause warnings to be shown after each statement if there are any. This option applies to interactive and batch mode. In interactive mode, `\w' and `\W' may be used to enable and disable warning display. (Bug #8684) * Removed a limitation that prevented use of FIFOs as logging targets (such as for the general query log). This modification _does not apply_ to the binary log and the relay log. (Bug #8271) * Added a `--debug' option to `my_print_defaults'. * When the server cannot read a table because it cannot read the `.frm' file, print a message that the table was created with a different version of MySQL. (This can happen if you create tables that use new features and then downgrade to an older version of MySQL.) (Bug #10435) * `SHOW VARIABLES' now shows the `slave_compresed_protocol', `slave_load_tmpdir' and `slave_skip_errors' system variables. (Bug #7800) * Removed unused system variable `myisam_max_extra_sort_file_size'. * Changed default value of `myisam_data_pointer_size' from 4 to 6. This allows us to avoid `table is full' errors for most cases. * The variable `concurrent_insert' now takes 3 values. Setting this to 2 changes MyISAM to do concurrent inserts to end of table if table is in use by another thread. * New `/*' prompt for `mysql'. This prompt indicates that a `/* ... */' comment was begun on an earlier line and the closing `*/' sequence has not yet been seen. (Bug #9186) * If strict SQL mode is enabled, `VARCHAR' and `VARBINARY' columns with a length greater than 65,535 no longer are silently converted to `TEXT' or `BLOB' columns. Instead, an error occurs. (Bug #8295, Bug #8296) * The `INFORMATION_SCHEMA.SCHEMATA' table now has a `DEFAULT_COLLATION_NAME' column. (Bug #8998) * `InnoDB': When the maximum length of `SHOW INNODB STATUS' output would be exceeded, truncate the beginning of the list of active transactions, instead of truncating the end of the output. (Bug #5436) * `InnoDB': If `innodb_locks_unsafe_for_binlog' option is set and the isolation level of the transaction is not set to serializable then `InnoDB' uses a consistent read for select in clauses like `INSERT INTO ... SELECT' and `UPDATE ... (SELECT)' that do not specify `FOR UPDATE' or `IN SHARE MODE'. Thus no locks are set to rows read from selected table. * Updated version of `libedit' to 2.9. (Bug #2596) * Removed `mysqlshutdown.exe' and `mysqlwatch.exe' from the Windows With Installer distribution. Bugs fixed: * `MERGE' tables could fail on Windows due to incorrect interpretation of pathname separator characters for filenames in the `.MRG' file. (Bug #10687) * Fixed a server crash for `INSERT ... ON DUPLICATE KEY UPDATE' with `MERGE' tables, which do not have unique indexes. (Bug #10400) * Fix `FORMAT()' to do better
RE: email notification
If you use MyISAM tables you could always do: SHOW TABLE STATUS LIKE 'tablename' Then look at the Update_time column. If that has changed since last time then something has changed. Then implement a php/perl/whatever script around it to email you. Note: On my InnoDB tables this time seems to be quite often NULL, so I guess it's not implemented in InnoDB. Best regards, Richard Dale. Norgate Investor Services - Premium quality Stock, Futures and Foreign Exchange Data for markets in Australia, Asia, Canada, Europe, UK USA - www.premiumdata.net -Original Message- From: Jayson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 31 May 2005 23:59 To: mysql@lists.mysql.com Subject: email notification I'm looking for a feature in mysql where it will email me if ther are any changes in a particular database or table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do you become a MySQL DBA
iH Mark, i work for a small independent telco where i have developed a number of apps that interface with class 5 switches and other telco gear. if you would like to email me off list i would be happy to give more details On May 31, 2005, at 2:50 PM, Mark Ahlstrom wrote: Here's an odd question for you, how do you become a MySQL DBA? I've got enough Solaris/Linux Experience under my belt and I was a Jr. Oracle DBA for a year, which got me really interested in RDBMS. I try to work with MySQL as much as possible, but I work with one of those large telco's that does not like anything where they can't pay large amounts of money. This means I have to work it into my spare time. I've been trying to tie MySQL into basic services: ftp, DSPAM, pop3, AND offer help for what we do have: running backups and repairing the odd table when needed. But the question is, what else could I do to help develope DBA skills? Right now I have very little data that goes beyond 2 tables, so my query skills are withering. Rich Allen A kidney transplant saved my life, plese consider being an organ donor. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do you become a MySQL DBA
Hi Mark, (B (BThat is actually a very interesting question. (B (BI found the "Certification study guide" from Paul DuBois an indispensible (Bguide. (B (BOther then what you would expect from a "study guide" it does actually go (Bmuch further than just preparing you for an exam. (B (BYou will get a whole lot of new ideas how to use and administrate your db. (B (BI am not sure, if the current version of the book still contains the 50$ (Bdiscount exam voucher (which would basically oay for the book if you would (Bbe going to take an exam ;-) (B (B (BIf you ned to spend the bugs of your company, why dont you opt for a (Bsupport contract directly from MySQL. That asures you that you have (Bsupport right when you need it. (B (B (BThe MySQL mailing list is a great way to ask questions and get them (Banswered generally in a matter of minutes, however the managers in your (Bcompany may feel better when they can get assigned their personal MySQL (Bstaff. (B (B (BI hope that this gives you an idea. (B (BBest regards (B (BNils Valentin (BTokyo / Japan (Bhttp://www.be-known-online.com/mysql (B (B (B (B (B (B Here's an odd question for you, how do you become a MySQL DBA? (B (B I've got enough Solaris/Linux Experience under my belt and I was a Jr. (B Oracle DBA for a year, which got me really interested in RDBMS. I try (B to work with MySQL as much as possible, but I work with one of those (B large telco's that does not like anything where they can't pay large (B amounts of money. This means I have to work it into my spare time. (B (B I've been trying to tie MySQL into basic services: ftp, DSPAM, pop3, (B AND offer help for what we do have: running backups and repairing the (B odd table when needed. (B (B But the question is, what else could I do to help develope DBA skills? (B Right now I have very little data that goes beyond 2 tables, so my (B query skills are withering. (B (B mediis a t gmail d o t com (B (B -- (B MySQL General Mailing List (B For list archives: http://lists.mysql.com/mysql (B To unsubscribe: (B http://lists.mysql.com/[EMAIL PROTECTED] (B (B (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not using optimum disk throughput.
On Sat, 2005-05-07 at 08:18, Greg Whalin wrote: Hi Peter, As for reporting bugs ... http://bugs.mysql.com/bug.php?id=7437 http://bugs.mysql.com/bug.php?id=10437 We have found Opteron w/ Mysql to be an extremely buggy platform, especially under linux 2.6, but granted, we are running Fedora. Perhaps we will try Suse, but I feel I have heard similar reports (from Friendster) about their use of Suse 2.6 and Opterons being similarly slow. Well, if I'm not mistaken Friendster had been running into some bugs with Linux kernel but it was not directly Opteron related. We are currently running MyIsam tables, but plan on switching to Innodb in the next month or two btw, so our performance problems are w/ MyIsam. Do you still have the problem ? I've seen you're using FC1 which is rather old. I have not heard about much of success of this version with Opteron. also did you run mysql-test on your MySQL server ? Does it pass at all ? If it does not it is just likely your build is broken or incompatible with your system. There are unfortunately two problems which affect both self compiler binaries and out binaries. Self compiled binaries could be affected by GLIBC bugs and compiler bugs which we've seen a lot when platform just appeared.Our static RPM may however have other problem - Opteron distributions are not 100% binary compatible for statically linked binaries and ie binary compiled on SuSE SLES is known to crash on RH AS in some cases. We have great adoption of opteron platform among our customers with great success rate, so I'm quite surprised by extent of problems you're having. -- Peter Zaitsev, Senior Performance Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL not using optimum disk throughput.
I've added a fair bit of information on the Opteron HOWTO Wiki at: http://hashmysql.org/index.php?title=Opteron_HOWTO for using Fedora Core 3 with X86-64. In my performance testing, I was finding that with so much RAM, everything was coming from RAM anyway. RAID10 seemed to be most stable, and writeback caching increased the speed by about 15% although I don't think I was really able to max out the IO anyway. Best regards, Richard Dale. Norgate Investor Services - Premium quality Stock, Futures and Foreign Exchange Data for markets in Australia, Asia, Canada, Europe, UK USA - www.premiumdata.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LEFT JOIN changes order of results
Hello, I have an application that does searches against a database of homes. A summary of initial search results is displayed by showing a few columns of information about each home. When the user clicks on one of the listings, it retrieves additional information (some from other tables) and displays more detailed information about the house. The summary listings are generated using a normal MySQL query. The detailed views are implemented by specifying which result row to display using a LIMIT clause. For example, if the user clicks on the 3rd listing on a page, the query will use this LIMIT clause: LIMIT 2,1 We do this instead of specifying a value for the primary key so we can have a Next and Previous button that will move between detailed listings. These result rows may pull information in from other tables for display. Sometimes the homes are sorted according to a particular column, and sometimes they aren't. Obviously this whole scheme depends on the homes staying in the same order between the summary queries and the detail queries, even if the ordering is ambiguous. We've had this running for several years, and it's always worked fine. We're now seeing some problems with it, possibly because of a move from a server running MySQL 3.x to one running 4.x. The problem we're seeing is that when additional tables are pulled in for the detailed view, the order is different from the summary view, so the wrong homes are displayed. Here's a simplified example. A summary query might ask: mysql SELECT lutar_homes.mls_num, lutar_images.num_images, lutar_homes_supplemental.address, lutar_homes.listdate FROM lutar_homes, lutar_homes_supplemental LEFT JOIN lutar_images ON lutar_homes.mls_num = lutar_images.mls_num WHERE ((lutar_homes.listdate = (NOW() - INTERVAL '14 00:00:00' DAY_SECOND))) AND lutar_homes.mls_num = lutar_homes_supplemental.mls_num ORDER BY lutar_homes.listdate DESC LIMIT 1; +-++-++ | mls_num | num_images | address | listdate | +-++-++ | 051768 | 1 | 7540 Country Pride Lane | 2005-05-31 | +-++-++ 1 row in set (0.00 sec) When I add one more LEFT JOIN clause (the second one below) to get additional fields for the detailed view, I get a different first home, even though none of the search parameters have changed, and the table hasn't changed: mysql SELECT lutar_homes.mls_num, lutar_images.num_images, lutar_homes_supplemental.address, lutar_homes.listdate FROM lutar_homes, lutar_homes_supplemental LEFT JOIN lutar_images ON lutar_homes.mls_num = lutar_images.mls_num LEFT JOIN lutar_homes_stats ON lutar_homes.mls_num = lutar_homes_stats.mls_num WHERE ((lutar_homes.listdate = (NOW() - INTERVAL '14 00:00:00' DAY_SECOND))) AND lutar_homes.mls_num = lutar_homes_supplemental.mls_num ORDER BY lutar_homes.listdate DESC LIMIT 1; +-++--++ | mls_num | num_images | address | listdate | +-++--++ | 051770 | 9 | 9149 Frankenmuth | 2005-05-31 | +-++--++ 1 row in set (0.02 sec) This change in ordering screws up my system, since if the user clicked on the first result in the summary view, the detailed view may display a completely different home. So my question is: Is this normal behavior for MySQL, or is it a bug? Any suggestions for dealing with it? Thanks! Please let me know if any of this is confusing, and I'll clarify. ---ScottG. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]