INSERT .. VALUES - Revision history

Connor at 10:03, 17 July 2012

2012-07-17T10:03:34Z

Connor at 10:02, 17 July 2012

2012-07-17T10:02:22Z

Connor at 09:33, 17 July 2012

2012-07-17T09:33:07Z

Connor at 09:28, 17 July 2012

2012-07-17T09:28:52Z

Connor at 09:28, 17 July 2012

2012-07-17T09:28:23Z

Connor at 14:46, 12 July 2012

2012-07-12T14:46:51Z

Connor at 14:42, 12 July 2012

2012-07-12T14:42:24Z

Connor: Created page with "
schema:gisq

INSERT

The INSERT command is used to add a..."

2012-07-12T14:41:33Z

Created page with "<div class=params>schema:gisq</div> <source lang=sql class='tidy'> </source> <source lang=sql class='setup'></source> <h3>INSERT</h3> <p>The INSERT command is used to add a..."

New page

<div class=params>schema:gisq</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<h3>INSERT</h3>
<p>The INSERT command is used to add a new row to a table.</p>
<pre>INSERT INTO games(yr, city) VALUES (2012,'London')</pre>
<p>The table is <code>games</code><br/>
The column names are <code>yr</code> and <code>city</code><br/>
Strings in the literal values must be quoted with single quotes.</p>
<hr/>
<h2>Example</h2>
<table border='1' style=''>
<caption>games</caption>
<tr> <th>yr</th> <th>city</th> </tr>
<tr> <td align='right'>2000</td> <td>Sydney</td> </tr>
<tr> <td align='right'>2004</td> <td>Athens</td> </tr>
<tr> <td align='right'>2008</td> <td>Beijing</td> </tr>
</table>
<p>The table <code>games</code> shows the year and the city hosting
the Olympic Games.</p>
<p>You want to add the next Olympic games, in the year 2012, which will be held in London.</p>
<hr/>
<div class='qu'>
The INSERT statement adds a new row to the table:
<source lang='sql' class='def'>
INSERT INTO games(yr,city) VALUES (2012,'London');
SELECT * FROM games;
</source>

<source lang='sql' class='ans'>
INSERT INTO games(yr,city) VALUES (2012,'London');
SELECT * FROM games;
</source>
</div>

<p>See also</p>
<ul>
<li>[[INSERT .. SELECT]]
</ul>

<h2>What can go wrong</h2>
<div class='qu'>
Your INSERT statement may break some database rule such as the unique key requirement.
In this example there is a primary key on year - that means that there may not be two rows with the same year.
If you attempt to add a second row with 2008 for yr then you will get an error.
<source lang='sql' class='def'>
INSERT INTO games(yr,city) VALUES (2008,'Paris');
SELECT * FROM games;
</source>

@@ Line 44: / Line 44: @@
 <p>See also</p>
 <ul>
-   <li>[[INSERT .. SELECT]]
+   <li>[[INSERT_.._SELECT |INSERT .. SELECT]]
 </ul>

@@ Line 19: / Line 19: @@
 <p>You want to add the next Olympic games, in the year 2012, which will be held in London.</p>
 <hr/>
-<div class='qu'>
+<div class='ht'>
-The INSERT statement adds a new row to the table:
+<div class=params>schema:scott</div>
 <source lang='sql' class='def'>
 INSERT INTO games(yr,city)
@@ Line 34: / Line 48: @@
 <h2>What can go wrong</h2>
-<div class='qu'>
+<div class='ht'>
 Your INSERT statement may break some database rule such as the unique key requirement.
 In this example there is a primary key on year - that means that there may not be two rows with the same year.
 If you attempt to add a second row with 2008 for yr then you will get an error.
 <source lang='sql' class='def'>
 INSERT INTO games(yr,city)

@@ Line 1: / Line 1: @@
-<h3>INSERT</h3>
+<h1>INSERT</h1>
     <p>The INSERT command is used to add a new row to a table.</p>
     <pre>INSERT INTO games(yr, city) VALUES (2012,'London')</pre>

@@ Line 22: / Line 22: @@
 The INSERT statement adds a new row to the table:
 <source lang='sql' class='def'>
-INSERT INTO games(yr,city) VALUES (2012,'London');
+INSERT INTO games(yr,city)
 SELECT * FROM games;
 </source>
 <source lang='sql' class='ans'>
-INSERT INTO games(yr,city) VALUES (2012,'London');
+INSERT INTO games(yr,city)
 SELECT * FROM games;
 </source>

INSERT .. VALUES - Revision history

Connor at 10:03, 17 July 2012

Connor at 10:02, 17 July 2012

Connor at 09:33, 17 July 2012

Connor at 09:28, 17 July 2012

Connor at 09:28, 17 July 2012

Connor at 14:46, 12 July 2012

Connor at 14:42, 12 July 2012

Connor: Created page with "schema:gisq

INSERT

Connor: Created page with "
schema:gisq