HI ,
I am using java to call store procedure as following. However, the
program hangs when it reaches the line 30 below. Any clue to make it
works?
...
30: CallableStatement cs = myConn.prepareCall({ call proc1() });
31: cs.execute();
...
--
MySQL General Mailing List
For list archives:
deneme
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have seen nicer fast random row implement, but that will work.
Do you happen to have a snip of it, the one I have seems to lean
pretty heavy as far as I can tell, and on occasion, though rare, also
sends me an empty result set.
--
Scott
[EMAIL PROTECTED]
--
MySQL General Mailing List
Does anyone have a set of MySQL Visio stencils? Does such a beast exist?
Ben Wiechman
On Fri, May 2, 2008 at 6:58 AM, Scott Haneda [EMAIL PROTECTED] wrote:
I have seen nicer fast random row implement, but that will work.
Do you happen to have a snip of it, the one I have seems to lean pretty
heavy as far as I can tell, and on occasion, though rare, also sends me an
empty
Google:
http://www.google.com/search?hl=enq=MySQL+Visio+stencilsbtnG=Google+Se
arch
-Raj.
-Original Message-
From: Ben Wiechman [mailto:[EMAIL PROTECTED]
Sent: Friday, May 02, 2008 12:39 PM
To: mysql@lists.mysql.com
Subject: Visio Stencils
Does anyone have a set of MySQL Visio
I am trying to update a field on a record in a table. Here is the
statement I created:
UPDATE pdata SET pvalue = ( SELECT pvalue
FROM pdata
WHERE pentrytime =1207022400 )
WHERE pentrytime =117540;
However, I get the following error:
|#1093 - You can't specify target table 'pdata' for
You are better off with an UPDATE JOIN
UPDATE pdata A,pdata B
SET A.pvalue = B.pvalue
WHERE A.pentrytime = 117540
AND B.pentrytime = 1207022400;
Give it a try !!!
-Original Message-
From: Albert E. Whale [mailto:[EMAIL PROTECTED]
Sent: Friday, May 02, 2008 4:06 PM
To:
-Original Message-
From: Albert E. Whale [mailto:[EMAIL PROTECTED]
Sent: Friday, May 02, 2008 4:06 PM
To: mysql@lists.mysql.com
Subject: Update with select
I am trying to update a field on a record in a table. Here is the
statement I created:
UPDATE pdata SET pvalue = (
Hey everyone!! Just wanted you to know that it's that time. The
summer issue of MySQL Magazine will be coming out July the 15th. That
means that it is time to start gathering the articles. If you have
interest in having your words read by thousands of people and having
fame and fortune come
10 matches
Mail list logo