Happy Gnu Year to everyone!!
On Wed, Dec 31, 2008 at 11:30 PM, Prathima Rao wrote:
> HAPPY NEW YEAR
>
>
> - Original Message - From: "John Daisley" <
> john.dais...@mypostoffice.co.uk>
> To: "MySQL General List"
> Sent: Thursday, January 01, 2009 7:25 AM
> Subject: Happy New Year
>
>
>
HAPPY NEW YEAR
- Original Message -
From: "John Daisley"
To: "MySQL General List"
Sent: Thursday, January 01, 2009 7:25 AM
Subject: Happy New Year
Just thought I would take this opportunity to wish everyone on the list
a happy, prosperous and peaceful 2009.
John Daisley
Email: j
Hello mysql and Happy New Year,
I am working with a Forum database. It contains a forums table, a
posts table and a threads table. Some of the posts contain flash
objects that I can find using a query like this one:
SELECT `pagetext`, `postid` FROM `post` WHERE `pagetext` LIKE
'%someuniqueidentif
Just thought I would take this opportunity to wish everyone on the list
a happy, prosperous and peaceful 2009.
John Daisley
Email: john.dais...@butterflysystems.co.uk
Mobile: 07812 451238
MySQL Certified Database Administrator (CMDBA)
MySQL Certified Developer (CMDEV)
MySQL Certified Associate (
Truncate the time part of the datetime field when doing the compare
AND DATE_FORMAT(customer.created_dt, '%Y-%m-%d 00:00:00') BETWEEN '2008-12-30'
AND '2008-12-30'
Should work. Probably not the most efficient. The other options would be to
use take end date + 1 day, minue 1 second. That's e
>-Original Message-
>From: Johnny Withers [mailto:joh...@pixelated.net]
>Sent: Wednesday, December 31, 2008 1:13 PM
>To: MySQL General List
>Subject: Compare DATETIME to DATE
>
>Hi,
>I don't quite understand (or even know) what the "proper" way to compare
>a
>DATETIME column to a given DA
Hi,
I don't quite understand (or even know) what the "proper" way to compare a
DATETIME column to a given DATE value is. I've used various methods but I'd
like to know if there's a better way to compare these values.
Right now I have a query with this in the WHERE clause (customer.created_dt
is a
I'm just guessing, but if the slow query log time resolution is seconds,
perhaps 0.5 and higher rounds up?
Or, perhaps it has an index, but it can't be used in that query.
What does EXPLAIN [paste query here] tell you?
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Hi all,
As my query yesterday did not generate any responses (possibly it was too
long and maybe not well written) I am trying to simplify the query:
What does the following error mean:
ERROR: Error in Log_event::read_log_event(): 'read error', data_len: 173056,
event_type: 73
And what is the u
Hi All,
I have enabled slow query log.
Generally this file will have sql's which take more than long-query time to
execute and also sql's not using indexes.
But i see sql's which does not come under the above condition.
I have set the long-query time to 1 Sec .
The query takes less than 1 sec to e
Micah Stevens wrote:
If you want to control the server process, you'll need to start the
server process with those options, this mysqld, and the command line
options are here:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html
Thanks for the link, I am going through it.
For your purp
11 matches
Mail list logo
