There is likely a blindingly obvious solution to this, I need to do a
group by expression in my query and get the latest row based on a date
field in the same table.
Is this even possible, and any tips on how to do that?
Example of data and query:
---
Table:
=(pseudo table based on
PROTECTED]
Sent: 04 March 2008 16:56
To: Esbach, Brandon; MySQL User Group
Subject: Re: Getting the last item in a group by query?
On Tue, Mar 4, 2008 at 11:24 AM, Esbach, Brandon
[EMAIL PROTECTED] wrote:
Thanks for the reply,
Sorry, should have been more specific on that :).
I need to access
Is there any way to backup a complete database structure
(tables/fields/indexes/etc), without the data? Or even get a creation
script per table?
At present the only way I can think of is to restore a backup to another
server and just delete records (a legacy database with data hitting over
12GB,
]
Sent: 18 February 2008 11:24
To: Esbach, Brandon
Cc: MySQL User Group
Subject: Re: Backup table structure, not data
Is there any way to backup a complete database structure
(tables/fields/indexes/etc), without the data? Or even get a creation
script per table?
At present the only way I can
Baron,
Just feedback - worked perfectly.
Thanks again!
-Original Message-
From: Esbach, Brandon
Sent: 31 August 2007 14:46
To: Baron Schwartz
Cc: MySQL User Group
Subject: RE: Two/more seperately unique columns in a table?
Hi, and thanks Baron;
I should have been a bit clearer
Hi all,
I'm guessing this is a fairly common question, but I've drawn a blank so
far with all workarounds possible.
Here's the rough scenario:
We have data streaming in constantly from various offsite locations.
This comprises of several details: a session, a unit of that session,
and a
))?
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: 31 August 2007 14:28
To: Esbach, Brandon
Cc: MySQL User Group
Subject: Re: Two/more seperately unique columns in a table?
Hi,
Esbach, Brandon wrote:
Hi all,
I'm guessing this is a fairly common question, but I've