Copy selected fileds from one table to other

[rahulroshan]

Hi ,
I want to copy the selected fields,
eg:SELECT * FROM table1 where flag='1';

to another table ,table2

can anyone plz help me

[pritaeas]

http://dev.mysql.com/doc/refman/5.5/en/insert-select.html

INSERT INTO newtable (field1, field2) SELECT field1, field2 FROM oldtable WHERE flag = '1'

[rahulroshan]

thanks a lot :)

[pritaeas]

Please consider to mark this thread solved.