Create table from sql query
I've got a table that was imported from an Excel table that "just grewed" out of control. I want to normalize it for analytics and clarity, but I don't seem to find how. I'm probably staring right at it and not seeing what I need.
If this were a traditional SQL database I would issue a SQL command like:
create table cities as select distinct city from manuscripts
insert into cities (select distinct city from manuscripts)
but I don't see how I can get myself into a sort of DBA console -- or anyplace else -- to just abstractly execute SQLExecute() function calls.
What am I not seeing? RTFM with a page number is probably the answer I'm looking for.