Tuesday, December 08, 2009

moving data from one mysql table to another

if u need to  copy  primary key(here id)
 INSERT INTO new_table( id,nt1,nt2) SELECT  oid,ot1,ot2 FROM old_table

else
 INSERT INTO new_table(nt1,nt2) SELECT  ot1,ot2 FROM old_table

No comments:

Post a Comment