Received: from rm-rstar.sfu.ca (root@rm-rstar.sfu.ca [142.58.120.21]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA38451 for ; Tue, 25 May 1999 13:27:00 -0400 (EDT) (envelope-from gburnham@sfu.ca) Received: from apemantus (apemantus.educ.sfu.ca [142.58.6.61]) by rm-rstar.sfu.ca (8.9.1/8.9.1/SFU-5.0H) with SMTP id KAA18842; Tue, 25 May 1999 10:26:55 -0700 (PDT) Message-ID: <010101bea6d3$fec842c0$3d063a8e@educ.sfu.ca> From: "Gregory W Burnham" To: "Zot O'Connor" , References: <374ADE8E.E7895F5@ZotConsulting.com> Subject: Re: [SQL] Stupid SQl question on inserting items Date: Tue, 25 May 1999 10:28:23 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 > This is a dumb basic level SQL question. > > is there any other way to insert records without having to fill in all > of the values as in > > INSERT into table_name WITH VALUES (blah, blah, blah...) Yes, you can INSERT into table_name (field_one, field_two, field_five) VALUES (value_one, value_two, value_five); Gregory W Burnham Software Engineer / Systems Administrator Excite Labs Simon Fraser University Vancouver, BC V5A 1S6 604 291 3615 ph 604 291 5679 fx