Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
m
Text replace - "http://www.basex.org/" to "http://www.basex.org/modules/"
The SQL Module contains [[Querying#Functions|XQuery functions]] to access relational databases from XQuery using SQL. With this module, you can execute query, update and prepared statements, and the result sets are returned as sequences of XML elements representing tuples. Each element has children representing the columns returned by the SQL statement. All functions dealing with access to relational databases use the <code>sql</code> prefix, which is linked to the <code><nowiki>http://www.basex.org/modules/sql</nowiki></code> namespace. The module will be officially supported with the upcoming {{Version|7.0}} of BaseX.
==sql:init==
<pre class="brush:xml">
<sql:row xmlns:sql="http://www.basex.org/modules/sql">
<sql:column name="cof_name">French_Roast</sql:column>
<sql:column name="sup_id">49</sql:column>
<sql:column name="total">30</sql:column>
</sql:row>
<sql:row xmlns:sql="http://www.basex.org/modules/sql">
<sql:column name="cof_name">French_Roast_Decaf</sql:column>
<sql:column name="sup_id">49</sql:column>
<sql:column name="total">14</sql:column>
</sql:row>
<sql:row xmlns:sql="http://www.basex.org/modules/sql">
<sql:column name="cof_name">Colombian_Decaf</sql:column>
<sql:column name="sup_id">101</sql:column>
