Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 Feb 2004 @ 15:16:43 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Insert Values problem
From:   Agarwal, Rachana


I have created a table with 2 fields , both having datatype as integer using :-

create table temp1(id1 integer , val1 integer) ;

After creating the table when I try to insert records in the table using

1) Insert into temp1 (id1,val1) values (1,2);


2 ) Insert into temp1 values (1,2);

Both of the above insert statements returns an error saying " too many values ".

However if I try to insert using following :-

3) Insert into temp1 select 1,2

It works fine.

Can anyone explain why first two insert statement does not work.

Thanks and Regards,


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023