<?xml version="1.0"?>
<?xml-stylesheet type="text/css" href="http://sqlzoo.net/w/skins/common/feed.css?303"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>http://sqlzoo.net/w/index.php?title=INSERT:_Not_all_fields_need_to_be_specified&amp;feed=atom&amp;action=history</id>
		<title>INSERT: Not all fields need to be specified - Revision history</title>
		<link rel="self" type="application/atom+xml" href="http://sqlzoo.net/w/index.php?title=INSERT:_Not_all_fields_need_to_be_specified&amp;feed=atom&amp;action=history"/>
		<link rel="alternate" type="text/html" href="http://sqlzoo.net/w/index.php?title=INSERT:_Not_all_fields_need_to_be_specified&amp;action=history"/>
		<updated>2013-05-20T16:05:41Z</updated>
		<subtitle>Revision history for this page on the wiki</subtitle>
		<generator>MediaWiki 1.20.4</generator>

	<entry>
		<id>http://sqlzoo.net/w/index.php?title=INSERT:_Not_all_fields_need_to_be_specified&amp;diff=1454&amp;oldid=prev</id>
		<title>Marek: Created page with &quot;INSERT: Not all fields need be specified. Default values may be specified in the CREATE TABLE clause - otherwise NULL is used. &lt;div class='ht'&gt; &lt;div class=params&gt;schema:scott&lt;...&quot;</title>
		<link rel="alternate" type="text/html" href="http://sqlzoo.net/w/index.php?title=INSERT:_Not_all_fields_need_to_be_specified&amp;diff=1454&amp;oldid=prev"/>
				<updated>2012-07-17T10:24:50Z</updated>
		
		<summary type="html">&lt;p&gt;Created page with &amp;quot;INSERT: Not all fields need be specified. Default values may be specified in the CREATE TABLE clause - otherwise NULL is used. &amp;lt;div class=&amp;#039;ht&amp;#039;&amp;gt; &amp;lt;div class=params&amp;gt;schema:scott&amp;lt;...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;INSERT: Not all fields need be specified. Default values may be specified in the CREATE TABLE clause - otherwise NULL is used.&lt;br /&gt;
&amp;lt;div class='ht'&amp;gt;&lt;br /&gt;
&amp;lt;div class=params&amp;gt;schema:scott&amp;lt;/div&amp;gt;&lt;br /&gt;
&amp;lt;div&amp;gt;&lt;br /&gt;
&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=sql class='tidy'&amp;gt;DELETE FROM t_peep WHERE id=99&amp;lt;/source&amp;gt;&lt;br /&gt;
&amp;lt;source lang=sql class='setup'&amp;gt;&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang='sql' class='def'&amp;gt;INSERT INTO t_peep (id) VALUES (99);&lt;br /&gt;
SELECT * FROM t_peep&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&amp;lt;div class=&amp;quot;ecomm e-mysql&amp;quot; style=&amp;quot;display: none&amp;quot;&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
{{INSERT and DELETE ref}}&lt;/div&gt;</summary>
		<author><name>Marek</name></author>	</entry>

	</feed>