Sam,
Remove the double quotes and semi-colon out of this statement:
$tmp_sql = qq{alter table tmp_pastsales add index(salescode,basename,prodcode)};
Clint
From: sam wun <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: create indexes for temporary table Date: Sun, 23 Jan 2005 18:49:51 +0800
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
