Answers for "move data from oldtable to new table"

0

move data from oldtable to new table

alter table tablename rename to oldtable;
create table tablename (column defs go here);
insert into tablename (col1, col2, col3) select col1, col2, col3 from oldtable;
Posted by: Guest on May-22-2021

Code answers related to "move data from oldtable to new table"

Browse Popular Code Answers by Language