Re: Question about MySQL
Hi Gavin, I am interested in the things you made for the optimization. Can you share with us such things? Thanks a lot, -- Banyan He Network System Security Infrastructure Mail: ban...@rootong.com Blog: http://www.rootong.com/blog LinkedIn: http://www.linkedin.com/in/banyanhe Website: http://www.rootong.com From: Gavin Towey gto...@ffn.com Date: Fri, 7 Aug 2009 11:07:19 -0700 To: joerg.bru...@sun.com joerg.bru...@sun.com, Peter Chacko peterchack...@gmail.com Cc: mysql mysql@lists.mysql.com Subject: RE: Question about MySQL I always accepted that NFS was unacceptably slow for database access, until I actually tested it. Turns out that with lots of RAM and properly tuned caches, you're optimizing for minimal IO anyway. A good file server will have massive amounts of IO OPS. On top of that if you're using GigE over few hops, then it's really not slower than local disks. Remember: benchmark and test your assumptions! Regards, Gavin Towey -Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: Friday, August 07, 2009 1:19 AM To: Peter Chacko Cc: mysql Subject: Re: Question about MySQL Hi Peter, all, let me just concentrate on the NFS aspect: Peter Chacko wrote: [[...]] Another question is , whats the general experience of running MySQL servers on NFS shares ? I would *never* use NFS storage for any DBMS (except for some testing): NFS access is slower than local disk access, and it adds more components to the critical path. So your operations get slower, reliability decreases, and (in case of any trouble) analysis becomes more difficult. I cannot imagine any setup where you have a machine strong enough to run your DBMS on it, but not capable of driving sufficient local disks. The typical argument for having centralized disks serving many machines is based on economies of scale (huge disks), flexibility (partitioning), and centralized management (RAID replacement, backup). There may be some merit to this in a specialized setup (NAS systems - I'm not convinced of them, but don't claim expert knowledge about them), but IMO not using general-purpose machines and NFS. Whatever the economical advantages during normal operation may be, you should not forget the huge costs you would incur if any in-between component breaks and your database stops operating. This may be tolerable for some applications, depending on the required availability, but simply intolerable for others. We are working on developing a custom protocol for MySQL clustering that takes care of all file management as part of the database clustering protocol, rather than a storage engine feature. Sorry, I don't get the meaning of this in sufficient detail to comment. What are the likely setup of a database storage ? Is it on RAW partition or on a File system ? That may depend on the storage engine used. MyISAM uses a file-per-table approach, so must be run on a file system; InnoDB may be able to use a raw partition (I'm not sure there); for others, I can't tell. Will ocfs2 be better used for mySQL as well, in a clustered environment ? I strongly doubt it. AIUI, the big advantage of cluster file systems is that they allow all machines to access and modify shared data. With a DBMS, you don't want to share data across machines, you want the database to be accessed only be the one machine (possibly multi-CPU, but shared memory) running the database processes, because on that machine you have the various database caches. Then, that machine makes the data available to all clients, so you get a logical sharing on a higher protocol level (SQL). To have multiple machines accessing the same database storage, you would first need some protocol to ensure cache coherency, and that is not contained in MySQL (in the general server). To use MySQL on multiple machines for the same data, you set up replication. The alternative approach would be to use MySQL Cluster, which is designed to hold the data in main memory (for extremely low latency) and to use the disk only for backup purposes. I would appreciate if any one share with me their thoughts on this. My comments above are based on my experience during DBMS development (including distributed DBMS), but not on any financial calculations or DBA work. Weigh them with other answers. Regards, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission
Re: Does anyone know how mysql works for mutiple kernels of a cpu.
Hiya, I think this one may be helpful. http://www.mysql.com/search/?q=processorscharset= Amit Sharma wrote: Hi Moon's Father, I thought you meant how mysql works for multiple processors of a cpu. If so, have a look at 'http://www.google.com/search?q=mysql+for+multiple+processors' Regards, Amit Sharma [EMAIL PROTECTED] Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: www.affle.co.uk -Original Message- From: Moon's Father [mailto:[EMAIL PROTECTED] Sent: 18 December 2007 12:33 To: mysql@lists.mysql.com Subject: Does anyone know how mysql works for mutiple kernels of a cpu. Any reply is appreciated,thanks. -- Banyan He MailWeb Security Mobile: +86 13641777622 MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] AntiSpam Test: [EMAIL PROTECTED] AntiVirus Test: [EMAIL PROTECTED] Wemaster Mail: [EMAIL PROTECTED] Website: http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL only listens on localhost
Check your my.cf file a /etc/my.cf. To add the bind-address = ip at the end of the file. Restart your mysql. And grant the access to the user who you want to connect your database from where you can accept. Franz Edler wrote: Hello, Can anyone please give me a hint what I can do that MySQL also listens to the physical address of the host. I see that MySQL listen only to 127.0.0.1:3306 and therefore every connection via the physical interface is reset. What can I do? Regards Franz -- Banyan He MailWeb Security Mobile: +86 13641777622 MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] AntiSpam Test: [EMAIL PROTECTED] AntiVirus Test: [EMAIL PROTECTED] Wemaster Mail: [EMAIL PROTECTED] Website: http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error once backing up database
Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z:sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
The question is in this server, I cannot backup the database by issuing mysqldump. On another server, I can. I am sure nobody changes the settings. That's confusing to me. ant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and tables, thereby giving access to possibly sensitive data. It is in no way a serious restriction, it is a very important security feature. If you don't have the grant permission and need it, ask your database administrator to set up rights. Don't assume that what may be easier for you in other software environments, is the better solution. In this case, it clearly is not. regards, boro Banyan He schreef: Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
thx Ananda. I will try. Cheers, Ananda Kumar wrote: Hi Banyan, Permission can vary from database to database. Please ask your dba to grant you the permission and then try the mysqldump On 7/19/07, Banyan He [EMAIL PROTECTED] wrote: The question is in this server, I cannot backup the database by issuing mysqldump. On another server, I can. I am sure nobody changes the settings. That's confusing to me. ant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and tables, thereby giving access to possibly sensitive data. It is in no way a serious restriction, it is a very important security feature. If you don't have the grant permission and need it, ask your database administrator to set up rights. Don't assume that what may be easier for you in other software environments, is the better solution. In this case, it clearly is not. regards, boro Banyan He schreef: Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
Ananda, I cannot host the reasons. Just add one more parameter to avoid LOCK TABLES. mysqldump --lock-tables=false db That works. Cheers, Thx guys. Ananda Kumar wrote: Hi Banyan, Permission can vary from database to database. Please ask your dba to grant you the permission and then try the mysqldump On 7/19/07, Banyan He [EMAIL PROTECTED] wrote: The question is in this server, I cannot backup the database by issuing mysqldump. On another server, I can. I am sure nobody changes the settings. That's confusing to me. ant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and tables, thereby giving access to possibly sensitive data. It is in no way a serious restriction, it is a very important security feature. If you don't have the grant permission and need it, ask your database administrator to set up rights. Don't assume that what may be easier for you in other software environments, is the better solution. In this case, it clearly is not. regards, boro Banyan He schreef: Yes, the server shows me that. I cannot execute the grant command. This is a serious restriction software works with mysql. Ananda Kumar wrote: You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Thx Ananada. Actually, I don't have the admin permission on this server. The grant command is unavailable for me. I have no ideas about this. I install the software on two machines, one of them can issue this command and works fine with it. Another cannot. OS: windows 2003 Cheers, Ananda Kumar wrote: Looks like this user does hot have permission on message_tracker while connecting on the local host. try this. grant all on message_tracker to 'admin'@'localhost' mailto:[EMAIL PROTECTED] identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, *Banyan He* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Guys, I encounter an issue once I backup the database. mysqldump -u admin -phost --databases message_tracker z: sqlbackup.sql mysqldump: Got error: 1044: Access denied for user 'admin'@'localhost' to database 'message_tracker' when using LOCK TABLES I am using windows as the OS. Any advices will be appreciated. Regards, -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- --- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SPAM ?
What's kind of the message you guys mentioned? - Original Message - From: LP [EMAIL PROTECTED] To: 'MySQL List' mysql@lists.mysql.com Sent: Saturday, March 24, 2007 10:13 PM Subject: Re: SPAM ? Hi, I also get the problem of keep receiving the email from the email list Regards KEVIN - Original Message - From: Jacques Brignon [EMAIL PROTECTED] To: 'Jerry Schwartz' [EMAIL PROTECTED] Cc: 'MySQL List' mysql@lists.mysql.com Sent: Saturday, March 24, 2007 10:45 PM Subject: SPAM ? Hi, I keep receiving this message by several dozens each day, how can this be stopped? Regards Jacques -Message d'origine- De : Jerry Schwartz [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 mars 2007 17:53 À : [EMAIL PROTECTED]; 'James Tu' Cc : 'MySQL List' Objet : RE: Finding a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SPAM ?
I assume someone send the copy of the message. So that we get the duplications. Since we all reply to all the mail senders. - Original Message - From: Jacques Brignon [EMAIL PROTECTED] To: 'Banyan He' [EMAIL PROTECTED]; 'LP' [EMAIL PROTECTED]; 'MySQL List' mysql@lists.mysql.com Sent: Sunday, March 25, 2007 6:07 PM Subject: RE : SPAM ? Hi, What's kind of the message you guys mentioned? Its always the same message from the same author with the same content, same date same hour, it's the one below: -Message d'origine- De : Jerry Schwartz [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 mars 2007 17:53 À : [EMAIL PROTECTED]; 'James Tu' Cc : 'MySQL List' Objet : RE: Finding a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL 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]