2012/09/06 08:50 -0400, Mark Haney
>SELECT vLight.* FROM
>(SELECT lights.*, machine.mach_name from lights
>JOIN machine ON lights.mach_id = machine.mach_id
>ORDER BY date DESC) as vLight
>GROUP BY mach_id
How about
SELECT lights.*, machine.mach_name
FROM lights JOIN machine USIN
I have a bit of a performance/best practice question for those in the
know. I have a nested SQL statement that selects fields from a SELECT
that has a JOIN in it. Here's the SQL:
SELECT vLight.* FROM
(SELECT lights.*, machine.mach_name from lights
JOIN machine ON lights.mach_id = machine.mach
Also check for any firewall or NAT
On Sep 5, 2012 5:17 PM, "indrani gorti" wrote:
> Hi all,
> I am a newbie to work with the settings in mysql although I have used in
> very small applications before
> I am currently experimenting with very large tables and a few complicated
> queries. I am usin
- Original Message -
> From: "indrani gorti"
>
> Later I changed it to SET GLOBAL connect_timeout=60;
> However, I still find that the query loses the connection to mysql
> server after about 10 mins( 600.495 secs)
> I see that the connect_time is 60 though.
If I recall correctly, all t
