Create a copy of a table using SELECT

Using version 4.0.20a-nt under Win2K

I need to pull distinct rows from a table and create a new table
populated with those rows.

This I can do with 'create table two select select distinct whatever
from one'. However this only creates that column.

I'd like to pull out ALL columns that have that distinct whatever.
'DISTINCT' only seems to work on one column.

So I create a copy of the structure of the first table, 'create table
two select * from table one where 1=0', then try to 'update' the columns
in table two by setting them to the ones in the table one.

No worky.

I'm not sure if this is even doable in my version. Been reading 'MySQL'
[DuBois] and O'Reilly's 'Managing & Using MySQL' but not had any luck.
Can someone tell me if this is doable with my version, and if so, how?
--
Amer Neely
Home of Spam Catcher
W: www.softouch.on.ca
E: trudge@softouch.on.ca
Perl | MySQL | CGI programming for all data entry forms.
"We make web sites work!"