![]() |
| |||
| How can I do the following in MySQL. insert into table1 (col1, col2, col3) select col1, col2, somevalue as col3 from table1 MySQL doesn't allow you to select from the same table you are inserting into. Thank You |
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
| |