Bryan,
Maybe something like this would work?
select 1296158500 - (1296158500 % 3600)
Hope that helps,
Nathan
On Thu, Feb 24, 2011 at 08:41:58AM -0800, Bryan Cantwell wrote:
> How would I go about modifying a unix timestamp to actually represent
> the 'top of the hour' that it represents?
> F
Paul,
I think you could accomplish this by adding a subquery to your where clause,
like:
AND NOT EXISTS (SELECT * FROM mappings m where m.src_ip=src_ip)
Hope that helps.
Nathan
On Tue, Oct 12, 2010 at 03:19:36AM -0700, Paul Halliday wrote:
> I have 2 tables: events and mappings.
>
> what
I think you want to do something like this:
select prod, group_concat(category separator ', ')
from products
group by prod;
Hope this helps.
On Wed, Apr 07, 2010 at 08:37:04AM -0700, kalin m wrote:
>
> hi all...
>
> i have a bit of a problem with this:
>
> table products:
>
> --
On Thu, Oct 08, 2009 at 02:33:34PM -0700, Carlos Proal wrote:
> On 10/8/2009 4:19 PM, John Oliver wrote:
> > 1) When I select * from whatever; is there a way to have the results go
> > by one screen at a time?
> >
>
> You can limit output by delimiting your search ie
>
> select * from users li
Carlos,
I think this does what you want: (untested though)
UPDATE identities
SET email=replace(email, 'mail.', '')
WHERE email like '%mail.iamghost.com'
Regards,
Nathan
-Original Message-
From: Carlos Williams [mailto:carlosw...@gmail.com]
Sent: Wednesday, July 29, 2009 1:58 PM
To: my
Matt,
If you went with option #3, you could avoid the looping by using (tCount - 1)
as the LIMIT in the delete statement instead of always using 1.
Regards,
Nathan
-Original Message-
From: Matt Neimeyer [mailto:m...@neimeyer.org]
Sent: Tuesday, July 14, 2009 8:58 AM
To: mysql@lists.my
Walton,
The table in the select is getting locked for the duration of the query because
it is part of the insert statement. I don't know the technical reason for
this, but I know it works this way. (having experienced this behavior several
times myself) The only way (that I am aware of) to av
day))) then 2
when (date_field_1 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 3
else 4
end, date_field_3, date_field_2, date_field_1;
-Original Message-
From: Nathan Sullivan
Sent: Thursday, July 02, 2009 1:07 PM
To: 'Ravindra Harige
Ravindra,
Maybe something like this?
order by
case
when (date_field_1 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 1
when (date_field_2 between date(current_timestamp) and
date(date_add(current_timestamp, interval 2 day))) then 2
when (date_field_3
John,
I think this should work:
UPDATE members SET email=REPLACE(email, SUBSTRING(email,INSTR(email,'@')+1),
'Thanks_in_advance.com.com')
Regards,
Nathan
-Original Message-
From: John Furlong [mailto:john.furl...@rakutenusa.com]
Sent: Monday, June 29, 2009 12:54 PM
To: mysql@lists.my
Ray,
You can use the results of a query in a join with something like:
select tmp.id, t1.id
from (some_query_selecting_id) as tmp
join t1 on t1.id=tmp.id
Hope that helps.
Regards,
Nathan Sullivan
-Original Message-
From: Ray [mailto:r...@stilltech.net]
Sent: Tuesday, June 02, 2009
Neil,
You can turn on the general query log by adding a line like this to your
configuration file:
log=/var/log/mysql_queries.log
Regards,
Nathan
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, May 27, 2009 9:13 AM
To: [MySQL]
Subject: Log
12 matches
Mail list logo