*solved* How to move One table values to another table (with one extra field)

[rajmohan]

Hello guy

I am having two tables fields followed by

[b]table1[/b]

one
two
three

[b]table2[/b]
one
two
three
four

I want to move the values from table1 to table2
mysql_query("insert into table2(select * from table1 where id='1'");

it is not working how to write a query please help me

[Barand]

insert into table2 (one, two, three) select * from table1 where id='1'"

[rajmohan]

Yes working thanks