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

mysqld process usage high and long

admin said he only edited an e-mail 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: 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 i

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

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

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 info

RE: Weeding out duplicates

emp.id=table.id". 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 t

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

Re: Weeding out duplicates

m Users u1, >Users u2 where u1.email=u2.email; i *think* something 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

Weeding out duplicates

owing, 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 arch

Re: selecting rows that match two criteria

lect userid from answers where qid = 6 and lower(answer) like '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

selecting rows that match two criteria

d "Student" in question 5 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

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

ome fields quoted but not others into accout. I am sure someone else out there has done this. I am wondering what the best way to go about this is. Any help is greatly appreciated. Thank you, Jonathan Duncan - Before posting, pleas

Re: Inches and Degrees

d want to use a floating point column, read > > http://www.mysql.com/doc/P/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

Inches and Degrees

imple way would be to enter them as CHAR's 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

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