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
|
<!-- manual page source format generated by PolyglotMan v3.0.4, -->
<!-- available via anonymous ftp from ftp.cs.berkeley.edu:/ucb/people/phelps/tcltk/rman.tar.Z -->
<HTML>
<HEAD>
<TITLE>UPDATE(SQL) manual page</TITLE>
</HEAD>
<BODY>
<A HREF="sql.html">SQL Reference Contents</A>
<H2><A NAME="sect0" HREF="#toc0">NAME </A></H2>
update - replace values of attributes in a class
<H2><A NAME="sect1" HREF="#toc1">SYNOPSIS </A></H2>
<B>update
</B> classname <B>set </B> attname-1 = expression-1 <BR>
<tt> </tt><tt> </tt>[, attname-i = expression-i] <BR>
<tt> </tt><tt> </tt>[<B>from
</B> from-list] <BR>
<tt> </tt><tt> </tt>[<B>where </B> qual] <BR>
<H2><A NAME="sect2" HREF="#toc2">DESCRIPTION </A></H2>
<B>Update</B> changes the values of the
attributes specified for all instances which satisfy the qualification,
<I>qual</I>. Only the attributes to be modified need appear as atributes. <P>
Array
references use the same syntax found in <I><A HREF="select.l.html">select(l)</A>
.</I> That is, either single
array elements, a range of array elements or the entire array may be replaced
with a single query. <I>from-list</I> is a non-standard extension to allow columns
from other tables to appear in the target_list. <P>
You must have write access
to the class in order to modify it, as well as read access to any class
whose values are mentioned in the target list or qualification.
<H2><A NAME="sect3" HREF="#toc3">EXAMPLES
</A></H2>
-- <BR>
--Give all employees who work for Smith a 10% raise <BR>
-- <BR>
update emp <BR>
set sal = 1.1 * sal <BR>
where mgr = 'Smith' <BR>
<H2><A NAME="sect4" HREF="#toc4">SEE ALSO </A></H2>
create <A HREF="table.l.html">table(l)</A>
,
<A HREF="select.l.html">select(l)</A>
. <P>
<HR><P>
<A NAME="toc"><B>Table of Contents</B></A><P>
<UL>
<LI><A NAME="toc0" HREF="#sect0">NAME</A></LI>
<LI><A NAME="toc1" HREF="#sect1">SYNOPSIS</A></LI>
<LI><A NAME="toc2" HREF="#sect2">DESCRIPTION</A></LI>
<LI><A NAME="toc3" HREF="#sect3">EXAMPLES</A></LI>
<LI><A NAME="toc4" HREF="#sect4">SEE ALSO</A></LI>
</UL>
</BODY></HTML>
|
