Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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);

OR

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,

Rachana

	<Prev	Next>		<<First	<Prev	Next>	Last>>