http://sqlzoo.net/w/index.php?title=UPDATE_existing_records&feed=atom&action=history
UPDATE existing records - Revision history
2013-05-23T09:57:59Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=UPDATE_existing_records&diff=1448&oldid=prev
Marek: Created page with "UPDATE can change an existing record. <div class='ht'> <div class=params>schema:scott</div> <div> </div> <source lang=sql class='tidy'>DROP TABLE t_peep;</source> <source lan..."
2012-07-17T10:14:41Z
<p>Created page with "UPDATE can change an existing record. <div class='ht'> <div class=params>schema:scott</div> <div> </div> <source lang=sql class='tidy'>DROP TABLE t_peep;</source> <source lan..."</p>
<p><b>New page</b></p><div>UPDATE can change an existing record.<br />
<div class='ht'><br />
<div class=params>schema:scott</div><br />
<div><br />
</div><br />
<br />
<source lang=sql class='tidy'>DROP TABLE t_peep;</source><br />
<source lang=sql class='setup'>CREATE TABLE t_peep (id INTEGER, name VARCHAR(10));<br />
INSERT INTO t_peep VALUES (1, 'Andrew');<br />
INSERT INTO t_peep VALUES (2, 'Gordon');<br />
</source><br />
<br />
<source lang='sql' class='def'>UPDATE t_peep<br />
SET name = 'andy', id=39<br />
WHERE id=1;<br />
SELECT * FROM t_peep<br />
</source><br />
<div class="ecomm e-mysql" style="display: none"></div><br />
</div><br />
<br />
{{INSERT and DELETE ref}}</div>
Marek