Re: automatic creation of table

[Rick James]

Seems like a dumb thing to do, unless it is a TEMPORARY TABLE.

Are you using DBI? DWIW?

With DBIx::DWIW, it would be something like:

$db->Execute(qq{CREATE TABLE foo$date (...)});
die $@ if $@;

With DBI, it is similar, but more verbose. That is, execute() the CREATE the same way you would execute() an INSERT.

Some ways to get a string with the current time:
my $date = scalar(localtime); # not good because of the spaces, etc
my $date = time(); # just a long number

Another choice for a reasonably unique string:
my $date = $$;
$$ is the operating system's process id (5-digit number?) of the script you are running.

Search Cpan for other Date:: packages that might do what you want.