db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r538767 - /db/derby/docs/trunk/src/devguide/cdevtricks807337.dita
Date Wed, 16 May 2007 22:35:36 GMT
Author: kahatlen
Date: Wed May 16 15:35:28 2007
New Revision: 538767

URL: http://svn.apache.org/viewvc?view=rev&rev=538767
Log:
DERBY-2053: Dev Guide: Syntax errors in SQL tips -> Tricks of the
VALUES clause -> Multiple rows

Patch contributed by John H. Embretsen.

Modified:
    db/derby/docs/trunk/src/devguide/cdevtricks807337.dita

Modified: db/derby/docs/trunk/src/devguide/cdevtricks807337.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/cdevtricks807337.dita?view=diff&rev=538767&r1=538766&r2=538767
==============================================================================
--- db/derby/docs/trunk/src/devguide/cdevtricks807337.dita (original)
+++ db/derby/docs/trunk/src/devguide/cdevtricks807337.dita Wed May 16 15:35:28 2007
@@ -35,10 +35,10 @@
     (3, 'third row')</b></codeblock>
 <p>Dynamic parameters reduce the number of times execute requests are sent
 across:</p>
-<codeblock><b><b>-- send 5 rows at a time:</b>
-PREPARE p1 AS 'INSERT INTO ThreeColumnTable VALUES 
-(?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?)
-EXECUTE p1 USING 'VALUES (''1st'',1,1,''2nd'',2,2''3rd'',
-3,3,''4th'',4,4,''5th'',5,5)'</b></codeblock>
+<codeblock>ij&gt; -- send 5 rows at a time:
+ij&gt; <b>PREPARE p1 AS 'INSERT INTO ThreeColumnTable VALUES 
+(?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?)';</b>
+ij&gt; <b>EXECUTE p1 USING 'VALUES (''1st'',1,1,''2nd'',2,2,''3rd'',
+3,3,''4th'',4,4,''5th'',5,5)';</b></codeblock>
 </conbody>
 </concept>



Mime
View raw message