mysqld process usage high and long

address on someone's account. Help? Thank you very much for your time, Jonathan Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld process usage high and long

Never mind, it was a query optimization issue. Upon the third interogation of the other admin, he remembered one small setting that he changed, which just so happened to increase the number of queries exponentially. Thanks, Jonathan Duncan On Mon, 6 Dec 2004, Jonathan Duncan wrote: Background

Re: MySQL Books

Very good feedback on multiple books. Thank you. So many good choices. If only I had time to read them all... Jonathan Ugo Bellavance [EMAIL PROTECTED] 11/23/04 7:46 am Kieran Kelleher wrote: This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks after MySQL

Re: MySQL Books

Sasha, Plugs from authors are interesting, but plugs from readers are what really sell a book. I will check it out though. Thank you for the response. Jonathan Sasha Pachev [EMAIL PROTECTED] 11/19/04 5:36 pm Jonathan Duncan wrote: I have the MySQL first edition book by Paul. Still

MySQL Books

reviews online for the following two books: -MySQL, Second Edition by Paul DuBois -Mastering MySQL 4 by Ian Gilfillan Any preferences between these two? Any better suggestions for learning MySQL front and back from a DBA perspective to an end user perspective? Thanks, Jonathan Duncan -- MySQL

Trying to match on something that is not there

the table Users. Thus, this of course seems to match on just about everything since there is no actualy record in the Users table to match on. Is there some way to match on a lack of information? Thanks, Jonathan Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: Weeding out duplicates

without the Internet and the amazing resource it makes everyone! Regards, Jonathan Duncan Robert A. Rosenberg [EMAIL PROTECTED] 07/10 8:09 pm At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding out duplicates: For the information of someone who may need it in the future

RE: Weeding out duplicates

entries and remove subsequent ones. Thanks, Jonathan Duncan Lachlan Mulcahy [EMAIL PROTECTED] 07/08 10:59 pm Jonathan, I'm not exactly sure what you want to do.. Do you want to identify the entries in the table where the email addresses are the same as another entry but the name

RE: Weeding out duplicates

. Thanks for the help. Jonathan Duncan Jonathan Duncan [EMAIL PROTECTED] 07/09 10:25 am Lachlan, I want to identify the entries in the table where the email addresses are the same as another entry. Whatever else is in the record does not matter to me. However, a second requirement

Re: selecting rows that match two criteria

'edu%' union automatically does a distinct so you will get one row back for each user that answered that they are education students. --- Jonathan Duncan [EMAIL PROTECTED] wrote: I am trying to figure out what my select statement should be to combine both of these into one: SELECT

Weeding out duplicates

, but not getting what I wanted. select distinct u1.id,u1.firstname,u1.lastname,u1.email from Users u1, Users u2 where u1.email=u2.email; How can I go about identifying the duplicate entries of email addresses? Thank you, Jonathan Duncan -- MySQL General Mailing List For list archives: http

Re: Weeding out duplicates

like this should work - select id,firstname,lastname,email from Users group by email having count(*)1; group and having are the keys, if/when that does not work. HTH Jeff How can I go about identifying the duplicate entries of email addresses? Thank you, Jonathan Duncan -- MySQL

selecting rows that match two criteria

and Education in question 6. I am using MySQL 4.08 so I can't do the subquery thing. Thanks, Jonathan Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Creating a database

Andrew, What you have done is correct. A database is merely a container. A container which is empty until you fill it will tables and then populate those tables with data. Regards, Jonathan Duncan Andrew Conkling [EMAIL PROTECTED] said: I am trying to host a message board through

Exporting Multi-DataType Excel Worksheet to CSV for Import into MySQL

what the best way to go about this is. Any help is greatly appreciated. Thank you, Jonathan Duncan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Inches and Degrees

/r/Problems_with_float.html first. If I were me, and the site wasn't dealing in many metric tools, I'd probably use the first method. At 07:43 PM 12/12/01 , Jonathan Duncan wrote: I am creating a database for a website that sells tools. Unfortunately they aren't measured in metric

Inches and Degrees

and forget about them, but then searching on that could cause problems. Does anyone have any idea what would be the best way to enter these number and as what type? Thanks in advance, Jonathan Duncan - Before posting, please check

Database Design

Does anyone know of a good site or reference on database design? That would be efficient database design. I can make a database but I want to know how to plan one and make it very good. Any ideas? Thanks in advance. -- Jonathan Duncan nacnud.com administrator Nacnud, Inc