insert into table2 (col2) select col1 from table1 (for data)
iirc, at least in Oracle you could also do:
create table table2 as select col1 from table1 to create (and fill ?)
It's been a while; don't think MySQL supports that, I could be wrong ...
Last edited by chrism01; 06-19-2007 at 05:28 AM.