> > > I guess it is nothing to do with the query as it was working perfectly
> > > fine be4 installing the Navicat enterprise version 7.0.9 .thanks a lot
Why don't you install 7.2 full version? Why did you go back a few versions?
Martijn Tonies
Database Workbench - development tool for MySQL, and
> I guess it is nothing to do with the query as it was working perfectly
> fine be4 installing the Navicat enterprise version 7.0.9 .thanks a lot
>
> On 4/17/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> >
> > Hi Renish,
> > What is the query that you ran, please let us know.
> >
> > regards
> >
Hi Renish,
What is the query that you ran, please let us know.
regards
anandkl
On 4/17/07, Renish koshy <[EMAIL PROTECTED]> wrote:
I had a trial version of Navicat 7.2 in my system. Now I installed the
full
version 7.0.9 enterprise Navicat. After that when I run the existing
query,,I get a n
I had a trial version of Navicat 7.2 in my system. Now I installed the full
version 7.0.9 enterprise Navicat. After that when I run the existing
query,,I get a n error message -"Got error 1 from storage engine"..Could you
guys pls help me
I noticed that when I run a small query it works..Is it so
I think this is what you want to do:
SELECT t1.Division,t1.year, t1.units this_year_units, t2.units
last_year_units, case when t2.units is null then t1.units else
(t1.units-t2.units) end as Difference_Units
FROM `narra_table` t1 left join narra_table t2
on (t1.Division=t2.Division) and (t1.Ye
i have to write one query
DivisionUnitsYear
a 200 2004
a 300 2005
b 500 2004
b 800 2005
b 900 2006
c
t;
Sent: Friday, December 05, 2003 12:14 AM
Subject: Lost connection to MySQL server during query - pls help
Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win
XP Pro.
They t
; <[EMAIL PROTECTED]>; "Kiky" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, December 06, 2003 12:56 AM
Subject: RE: Lost connection to MySQL server during query - pls help
> At 10:44 -0600 12/5/03, Jay Blanchard wrote:
> >[snip]
> >Ple
At 10:44 -0600 12/5/03, Jay Blanchard wrote:
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
See t
"Kiky" <[EMAIL PROTECTED]> wrote:
> I have a problem with
> "Error 2013 - Lost connection to MySQL server during query"
>
> I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro.
> They turn out to have the same error.
>
> My problem is:
> I have a Java program which is
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
--
MySQL General Mailing List
For list archives:
At 14:14 5/12/2003 +0800, Kiky wrote:
Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win
XP Pro.
They turn out to have the same error.
Please upgrade you MySQL Windows client to 4.0.16
Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro.
They turn out to have the same error.
My problem is:
I have a Java program which is actually a thread to send emails, so it
>Ways around inner select statments
>Select ID, Sum(CASE WHEN phone.PHN = NULL THEN 1 ELSE 0 END) as PHNCount
>from person left outer join phone on ID
>where PHNCount = 0 GROUP BY phone.ID;
The alias in the WHERE clause is illegal; it would have to be
SELECT persons.ID,
Sum( CASE WHE
14 matches
Mail list logo
