how to copy one table data to another table

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ta.bu.shi.da.yu Hall of Fame Points: 3985 More actions · Answer 1

insert into table1

select * from table2

You need to be sure that the columns types match on both tables.

Random Technical Stuff[/url]

ps. One Orange Chip Points: 29422 More actions · Answer 2

ta.bu.shi.da.yu (8/7/2009)
insert into table1
select * from table2
You need to be sure that the columns types match on both tables.

to modify the code in the previous post, i'd write something like this

insert into table1

select * from table2 where id=1

Pradeep Singh

ta.bu.shi.da.yu Hall of Fame Points: 3985 More actions · Answer 3

Oops... sorry, didn't read that carefully enough.

Random Technical Stuff[/url]