copying selective feilds to a table

Discussion in 'Databases' started by smartminds, May 6, 2007.

0
  1. #1
    hi ppl
    i need to copy the table(with 6feilds) to another table(with 10 feilds )

    plz help
     
    smartminds, May 6, 2007 IP
  2. SoKickIt

    SoKickIt Active Member

    Messages:
    305
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    70
    #2 
    
INSERT INTO
	table_with_10_fields
	(field1, field2, field3, field4, field5, field6)
SELECT
	field1, field2, field3, field4, field5, field6
FROM
	table_with_6_fields
    Code (markup):
     
    SoKickIt, May 6, 2007 IP