Re: Basic SELECT help

Hi Neil Would something like this work. SELECT DISTINCT id,type from your_table WHERE type=2 OR type=5; Mike - Original Message - From: "Neil Tompkins" To: "[MySQL]" Sent: Thursday, November 22, 2012 9:30 AM Subject: Basic SELECT help Hi, I'm struggling with what I think is a

Re: Licensing question about mysql_com.h

You might not know about proxy services. I am in Canada and can watch hulu.com etc if I am proxied in. Currently I use HotSpot shield from anchorfree.com and they have a free version. Mike - Original Message - From: "Claudio Nanni" To: "Paul Vallee" Cc: "James Ots" ; Sent: We

Re: Beginner question

Hi Patrice I would try some brackets. Something like this should work SELECT * FROM listings WHERE listing_state = 'DC' AND listings.listing_show ='y' AND ( listings.cat1 = 23 OR listings.cat2 = 23 OR listings.cat3 = 23 ) Mike - Original Message - From: "Biz-comm" To: Sent:

Re: SQL book recommendation?

I have two of Paul's books and they are excellent. - Original Message - From: "Paul DuBois" To: "[MySQL] Mysql list" Cc: "MikeB" ; "Philip Riebold" Sent: Thursday, October 28, 2010 1:45 PM Subject: Re: SQL book recommendation? On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote:

Re: GRANT issues

Hi Steve Your statement will allow you to SELECT from any table in the pet_calendar database. You need to add INSERT, UPDATE, DELETE, CREATE etc to your GRANT statement. If you would like to have a super user, just GRANT ALL Mike - Original Message - From: "Steve Marquez" To: "

Re: Database fundamentals: wanna learn.

I have two of Paul's books. They are both fantastic. Mike O'Krongli President and CTO Acorg Inc 519 432-1185 - Original Message - From: "Claudio Nanni" To: "Ken D'Ambrosio" Cc: "mysql" Sent: Monday, December 28, 2009 10:33 AM Subject: Re: Database fundamentals: wanna learn. Hi K

Re: ndbcluster problem

Have you checked the type of column you are using. Depending on what the 108 number means, it could be altering the table to say int or bigint column. If it means total number of records, it does not seem to correspond to a medint value, either signed or not. If it means the record number

Re: FW: MySQL patches from Google

Hi I read the Google blog post regarding these patches. They admit using MySQL for some internal data storage needs but not in the general search system. Here is the link to the blog post http://google-code-updates.blogspot.com/2007/04/google-releases-patches-that -enhance.html Mike O'Kro

Show Description options??

Hi I was looking for a command that will list the names of my columns only. I have investigated show columns but there seems to be no way to return just the names. Any suggestions?? Thanks Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Cant access my files through the web site

Hi The problem here does not involve mysql. For better advice, try an apache or PHP group. From what I know, I would check directory permissions in the apache conf file. Mike - Original Message - From: "ghislain groulx" <[EMAIL PROTECTED]> To: Sent: January 8, 2006 1:19 PM Subjec

Re: Band width consume

I don't have any stats but I would assume it's as big as your select statement plus as big as the result set. Mike - Original Message - From: "Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> To: Sent: December 4, 2005 7:02 AM Subject: Band width consume > Dear Friends > > Is their an

Re: UPDATE and INDEX updates

think I will find the answer to this question in the normal >manuals > > but rather from someone / place that deals with the internals of the > >system. > > Mike > > MySQL internals are available at: > http://dev.mysql.com/doc/internals/en/ > > > > Mike

Re: UPDATE and INDEX updates

. I don't think I will find the answer to this question in the normal manuals but rather from someone / place that deals with the internals of the system. Mike - Original Message - From: "sheeri kritzer" <[EMAIL PROTECTED]> To: "Mike OK" <[EMAIL PROTECTED]

Re: UPDATE and INDEX updates

at it only needs to update different values -- for instance, it returns only the # of rows changed, not the # of rows looked at. Given that, I will extrapolate that MySQL is not going to re-work an index unless it actually changes a value. -Sheeri On 11/21/05, Mike OK <[EMAIL PROTECTED]> wro

UPDATE and INDEX updates

Hi I was wondering how the index process worked internally for UPDATE statements. If I was to "set" a value for a column with the UPDATE statement but the value was the same, would MySQL re-work the index?? I can check for data change for each column inside of my code before UPDATE but wa

Re: Avoiding filesort #2

Hi First, I am pretty sure that what the manual says is that MySQL only USES one index per request, not one index per table. I would try adding an index that starts with ColC (and maybe only ColC). Your index starts with ColA but you do not use it in your WHERE portion of the statement. Thi

Re: Avoiding filesort #2

- Original Message - From: "Homam S.A." <[EMAIL PROTECTED]> To: Sent: February 22, 2005 8:12 PM Subject: Avoiding filesort #2 > Actually with the query below it does avoid filesort, > but once I use anything other than the equal operator > (e.g. ColC > 5), it reverts back to filesort.