/usr/share/doc/stilts/sun256/sqlupdate.html is in stilts-doc 3.1.2-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="sun-style.css">
<title>sqlupdate: Updates values in an SQL table</title>
</head>
<body>
<hr>
<a href="sqlupdate-usage.html">Next</a> <a href="secB.18.2.html">Previous</a> <a href="cmdUsage.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="sqlupdate-usage.html">Usage</a><br>
<b>Up: </b><a href="cmdUsage.html">Command Reference</a><br>
<b>Previous: </b><a href="secB.18.2.html">Examples</a><br>
<hr>
<hr>
<h2><a name="sqlupdate">B.19 <code>sqlupdate</code>: Updates values in an SQL table</a></h2>
<p><code>sqlupdate</code> updates values in an existing table in an SQL
database. The rows to update are specified, as a normal
SELECT statement, using the <code>select</code> parameter.
Each column to update, and the value to write to it, are given using
the <code>assign</code> parameter.
</p>
<p>Why not just use the database's own UPDATE statement? In most cases,
that would be a much better idea. However, using <code>sqlupdate</code>
you can write values using STILTS's
<a href="jel.html">expression language</a>, and hence take
advantage of its various functions, without having to embed them into
the database. SQL column names can be used as variables in these expressions,
in the same way that table column names are used as variables in
other commands such as <code>tpipe</code>.
</p>
<p>This command can only be used if you have access to an SQL
database via JDBC. The details of how to configure a JDBC connection
to a database are discussed in <a href="jdbcConfig.html">Section 3.4</a> - obviously
you will need a database to connect to and appropriate write permissions
on it as well as the relevant drivers.
</p>
<p>This is a somewhat specialised command, and several
(database/driver-specific) things can go wrong with it.
If you do not have a fairly good understanding of the database with which
you are using it then you may run into problems (but then you'd be unlikely
to have the permissions to do the updates in any case).
</p>
<ul>
<li><a href="sqlupdate-usage.html">B.19.1 Usage</a></li>
<li><a href="secB.19.2.html">B.19.2 Examples</a></li>
</ul>
<hr><a href="sqlupdate-usage.html">Next</a> <a href="secB.18.2.html">Previous</a> <a href="cmdUsage.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="sqlupdate-usage.html">Usage</a><br>
<b>Up: </b><a href="cmdUsage.html">Command Reference</a><br>
<b>Previous: </b><a href="secB.18.2.html">Examples</a><br>
<hr><i>STILTS - Starlink Tables Infrastructure Library Tool Set<br>Starlink User Note256<br>STILTS web page:
<a href="http://www.starlink.ac.uk/stilts/">http://www.starlink.ac.uk/stilts/</a><br>Author email:
<a href="mailto:m.b.taylor@bristol.ac.uk">m.b.taylor@bristol.ac.uk</a><br>Mailing list:
<a href="mailto:topcat-user@jiscmail.ac.uk">topcat-user@jiscmail.ac.uk</a><br></i></body>
</html>
|