Perl always looks complicated; it is one of its charms. Seriously, the
script I posted is really fairly basic (IMHO) and, if I say so myself, well
commented.
It is possible. But I don't know Perl so it's a magic for me. ;-)
errors? why do you anticipate errors?
There are always errors. :-) Truly I meant that when I will be unable to change
anything and repair my own errors made during changes.
One thing 3.23 does have is 'create table foo select ...' which nicely
builds a 'foo' table that looks just like the results of your select...
Yeah. That's right. Yesterday I did it in more complicated way using SHOW CREATE
TABLE, replacing table name, executing CREATE TABLE and then INSERT ... SELECT
.... Your solution is much better.
Thank you for your help.