Copy one table to another table.

Question

Post reply

Copy one table to another table.

karthikptm

Grasshopper

Points: 15
More actions
March 29, 2012 at 12:55 am

#270932

Hi there,
I have two table personal and academic, In personal id, Ename, Qualification and some other columns are there. In Academic also have the certain columns and other columns too. Is there any query to copy all the id, ename and qualification from Personal to Academic.

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

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

Andy Hyslop SSCrazy Eights Points: 9198 More actions · Answer 1

Assuming that you just want to Insert all of the rows and not update existing rows:

INSERT INTO

Academic

(ID,Ename,Qualification)

(

SELECT

ID

,Ename

,Qualification

FROM

Personal

)

Andy

==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

baabhu SSCertifiable Points: 6205 More actions · Answer 2

Why this question has to appear on high availability?

karthikptm Grasshopper Points: 15 More actions · Answer 3

Thank you Andy, Am just a beginner for SQL. Now ly start learning. Your response is too much worth for me. The Query is working. Thank you.

Andy Hyslop SSCrazy Eights Points: 9198 More actions · Answer 4

Your Welcome

==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe