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
)