A admin Administrator Staff member Aug 21, 2008 #1 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..
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..
