Hi, I am mass-importing A LOT of csv tables. In order to distinguish between files I change the default value for the table before doing a "load data infile.." from a Perl script:
ALTER TABLE `data` MODIFY COLUMN `sample_id` INTEGER UNSIGNED NOT NULL DEFAULT $sample_id[$idx] After importing a few hundred files I now realize that the table is copied each time the "alter table statement is executed. Is there a way to avoid this? I think there at least should be a way since nothing in the structure is altered. Please advise! Thanks, Bernd