8 messages in com.mysql.lists.javaRe: Clever data dump
FromSent OnAttachments
Konrad Billewicz16 Aug 2005 07:19 
Jim Cant16 Aug 2005 18:38 
Konrad Billewicz17 Aug 2005 02:57 
Jim Cant17 Aug 2005 06:26 
Konrad Billewicz18 Aug 2005 06:36 
Ronald Klop23 Aug 2005 07:24 
A.J. Blanchard (ajblanch)28 Aug 2005 20:18 
tom-...@supanet.com29 Aug 2005 10:41 
Subject:Re: Clever data dump
From:Konrad Billewicz (konr@akonet.pl)
Date:08/18/2005 06:36:16 AM
List:com.mysql.lists.java

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.