ot: callablestatement

2008-05-02 Thread Rilawich Ango
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

2008-05-02 Thread Huseyin ERSOY
deneme -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Age old order by rand() issue

2008-05-02 Thread Scott Haneda
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

Visio Stencils

2008-05-02 Thread Ben Wiechman
Does anyone have a set of MySQL Visio stencils? Does such a beast exist? Ben Wiechman

Re: Age old order by rand() issue

2008-05-02 Thread Rob Wultsch
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

RE: Visio Stencils

2008-05-02 Thread Rajesh Mehrotra
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

Update with select

2008-05-02 Thread Albert E. Whale
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

RE: Update with select

2008-05-02 Thread Rolando Edwards
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:

Re: Update with select

2008-05-02 Thread Rob Wultsch
-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 = (

Call for Articles for MySQL Magazine - Summer Issue

2008-05-02 Thread B. Keith Murphy
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