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
sharing some tech problems and soln
if u need to copy primary key(here id)
INSERT INTO new_table( id,nt1,nt2) SELECT oid,ot1,ot2 FROM old_table
No comments:
Post a Comment