James Biggs <[EMAIL PROTECTED]> was heard to say:
>
> I can do for example
>
> $dbh->do( "CREATE TABLE my_table (etc etc etc)");
>
> but i don't know a Perl command for creating a table with many columns. I
> did not find one in the docs either. Thanks
>
Something along these lines (untested!!) should work:
my $command = "CREATE TABLE my_table (";
foreach my $counter (1..999) {
$columns .= "INT column" . $counter . ", ";
}
$command .= "INT column1000)";
print $command;
You may need to name your columns more intelligently.
regards,
Markus
--
Markus Hoenicka
[EMAIL PROTECTED]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
