1.
create table table_tmp as select * from table1
2.
insert into table_tmp
(select * from table1)
3.
update table_tmp
set (name,password) = (select name,password from table1)
4.
select tab_name from tables
where (tab_name,db_ver) =
(
select tab_name,db_ver from tab_columns
where version = 604
)