How to update a table in mysql

[Anon]

Hello, I'm new to mysql, I'm used to have Oracle's sub select ability. How do I do the following in mysql:

I have 2 tables, i want to copy the information from table 1 into table 2. so something like:

update table2 set col1 = table1.col1

thanks..

[sepodati]

INSERT INTO table1 (col1,col2,col3) SELECT col1,col2,col3 FROM table2;

---John Holmes...