Re: Not to show until a certain date

I would argue that it's not a logical error. Typically, in my experience when something expires, the date of expiry is inclusive, and any date after expiry is not. Take any discount, coupon, or promotion -- if it expires on December 31, it's still available on that day. If an article expires on

RE: Any way to change tinezone WITHOUT mysqld restart?

Did you even look at the manual? http://lmgtfy.com/?q=mysql+set+timezone First link. > -Original Message- > From: Bryan Cantwell [mailto:bcantw...@firescope.com] > Sent: Friday, October 01, 2010 10:25 AM > To: mysql@lists.mysql.com > Subject: Any way to change tinezone WITHOUT mysqld

Re: Not to show until a certain date

Hi Hank, all! Hank wrote: > On Fri, Oct 1, 2010 at 2:34 PM, Joerg Bruehe wrote: >> Hi! >> >> >> Hank wrote: >>> On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson >>> wrote: On 9/28/10 8:33 PM, Chris W wrote: > SELECT * > FROM announcements > WHERE announcements_expir

RE: Not to show until a certain date

Your suggestion seems more elegant. However, you missed the mathematical meaning of "BETWEEN" in SQL: it is inclusive of both lower and upper bounds. In the case raised by Patrice Olivier-Wilson, when an announcement expires on announcements_expiredate, it should not show on that date, and therea

RE: Indexing question

You can't use an index to select records in a range, and order them. The order by will cause a filesort in that case. Additionally indexes are always read left to right. So an index on ('user_id', 'product_id') will help when doing WHERE user_id=N AND product_id IN (1,2,3), but wouldn't help

Re: Not to show until a certain date

On Fri, Oct 1, 2010 at 2:34 PM, Joerg Bruehe wrote: > Hi! > > > Hank wrote: >> On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson >> wrote: >>> On 9/28/10 8:33 PM, Chris W wrote: >>> SELECT * FROM announcements WHERE announcements_expiredate > CURDATE() AND announcements_

Indexing question

Suppose I wanted to be able to perform queries against three columns of my table: 'user_id', 'product_id' and 'created'. Most of the time I'll just be range-selecting records from the table ordering by 'created'. But I may also want to select where 'user_id' = something and 'product_id' in (list, o

Re: Not to show until a certain date

Hi! Hank wrote: > On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson > wrote: >> On 9/28/10 8:33 PM, Chris W wrote: >> >>> SELECT * >>> FROM announcements >>> WHERE announcements_expiredate > CURDATE() >>> AND announcements_postdate <= CURDATE() >>> ORDER BY announcements_expiredate ASC >

Re: Replication / standby option on MySQL (GA)

Hi everbody! Machiel Richards wrote: > Hi Guys > > Can someone please confirm whether replication / standby > functionality is available on the GA release of MySQL or this an > Enterprise specific functionality? 1) Replication is available in all MySQL configurations, be they for the com

Any way to change tinezone WITHOUT mysqld restart?

Any way to change timezone WITHOUT mysqld restart? It would be a lifesaver if there were some way for me not to have to restart because if mysql restarts then I have to go through a lot of other issues with my other apps.

RE: Object audit info

Alternatively, if you only want to log modifications, then the binlog would suffice. -Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Friday, October 01, 2010 6:21 AM To: PRATIKSHA JAISWAL Cc: mysql@lists.mysql.com Subject: Re:

RE: possible curdate() issue

You're using incorrect syntax for date math. Use: CURDATE() - INTERVAL 1 day See the manual for details. -Original Message- From: Ted Maas [mailto:tm...@uic.edu] Sent: Friday, October 01, 2010 7:47 AM To: mysql@lists.mysql.com Subject: possible curdate() issue This is most likely user

Add "record number" to timestamped router data to facilitate cross join

All, I have a number of routers which report in with various stats periodicially. This period is not a regular interval and can drift based on other factors. Each router drifts independently. The stats the routers provide need to be analyzed in terms of deltas between reports (rather than the a

possible curdate() issue

This is most likely user error but I noticed today that when I subract 1 from the curdate() function I get a very interesting result: mysql> select curdate() - 1 from dual; +---+ | curdate() - 1 | +---+ | 20101000 | +---+ 1 row in set (0.00 sec) curdate(

Re: Replication / standby option on MySQL (GA)

This is in the GA (free) release and has been for many years I believe... Quoting Machiel Richards : Hi Guys Can someone please confirm whether replication / standby functionality is available on the GA release of MySQL or this an Enterprise specific functionality? Regards Machiel

Replication / standby option on MySQL (GA)

Hi Guys Can someone please confirm whether replication / standby functionality is available on the GA release of MySQL or this an Enterprise specific functionality? Regards Machiel

Re: Object audit info

Simply activate the full log ("log" directive in my.cnf) - this will provide you with logon, logoff and every command sent by every session. Keep in mind that this is a LOT of data; so you want to keep this on a separate set of spindles. It will also. obviously, make for some overhead, but if your

Object audit info

Hi List, How can i audit every object of the database including database too. I will give you deep idea about it. Our environment having lots of application connected to database. We have created user specific to applications, which has admin rights. Now, i wanted to monitor/audit information in