rajmohan Posted September 20, 2006 Share Posted September 20, 2006 Hello guy I am having two tables fields followed by[b]table1[/b]one twothree[b]table2[/b]one twothreefourI want to move the values from table1 to table2mysql_query("insert into table2(select * from table1 where id='1'"); it is not working how to write a query please help me Quote Link to comment Share on other sites More sharing options...
Barand Posted September 20, 2006 Share Posted September 20, 2006 insert into table2 (one, two, three) select * from table1 where id='1'" Quote Link to comment Share on other sites More sharing options...
rajmohan Posted September 20, 2006 Author Share Posted September 20, 2006 Yes working thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.