create indexes for temporary table

[sam wun]

Hi,
I want to create indexes for temporary created tables in perl dbi.
The following is perl code that I tried, but perl dbi seems not allow 
the syntax:

Unable to execute our query PastSales:You have an error in your SQL 
syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near '"alter table tmp_pastsales add 
index(salescode,basename,prodcode);"' at line 1 Unable to execute our 
query Sales:You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near '"alter table tmp_sales add index(salescode,basename,prodcode);"' 
at line 1

This is the actual perl code I use:
$tmp_sql = qq{"alter table tmp_pastsales add 
index(salescode,basename,prodcode);"};
$sth_tmp = $dbh->prepare($tmp_sql) or print "Unable to prep our 
query:".$dbh->errstr."\n";
$sth_tmp->execute or print "Unable to execute our query 
PastSales:".$dbh->errstr."\n";

Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]