move data from oldtable to new table code example

Example: 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;