Re: table name as variable in INSERT

[B A]

I did, and this is the error message I get now:

DBD::mysql::st execute failed: Table 'perltest.$table' doesn't exist at ptest.pl line 22.
SQL error:$DBI::errstr

my code now reads:
my $ins_rec="INSERT INTO \$table\ (symbol) VALUES(\'$name\');";