How to cope data from table-1 to table-2

Question

getting data of table-1 and copy on table-2

Answer 1

okay , Thank you very much

Answer 2

select from table 1, insert into table 2, remember to specify columns and rows. e.g. INSERT INTO table2 (fieldnames) SELECT fieldnames FROM table1

Answer 3

If both tables are truly the same schema:

INSERT INTO newTable
SELECT * FROM oldTable

Otherwise, you'll have to specify the column names (the column list for newTable is optional if you are specifying a value for all columns and selecting columns in the same order as newTable's schema):

INSERT INTO newTable (col1, col2, col3)
SELECT column1, column2, column3
FROM oldTable