How To Copy Data From One Table to Another Table Having Data

If i have two table T1 having data of column C1,C2,C3 and C4 and T2 having data of column C5,C6,C7 and C8,How to copy Data of T2 to T1 or T1 to T2

Showing Answers 1 - 9 of 9 Answers

sameen
Profile Answers by sameen

Mar 21st, 2015

Insert Into t2
Select * from t1

smamish
Profile Answers by smamish

Mar 21st, 2015
Code
INSERT INTO T1 (CQ,C2,C3,C4) 


SELECT C5,C6,C7,C8


 

Aakash

Mar 22nd, 2015

INSERT INTO T1
(
SELECT
C5,
C6,
C7,
C8
FROM T2)

It looks like you are using an AD Blocker!

Please Turn OFF your ad blocker

- OR -

Disable
Ad Blocker

Create your
GeekInterview account

Continue Reading after Disabling