Deleting Rows in SAS

How can I update my MySQL database with data I have from a SAS Data Set without 
losing my primary key and other formatting? I am trying to simply delete all 
rows and import all again, but I get the following error message. It seems that 
any time I try to update by removing old data and inserting new data, I get 
this message. Any help would be wonderful. 

Proc sql;
  DELETE * FROM mysql.testtable;

ERROR: Error updating table entry: [MySQL][ODBC 3.51
       Driver][mysqld-5.0.41-community-nt-log]Optional feature not implemented
ERROR: ROLLBACK issued due to errors for data set MYSQL.testtable.DATA.
NOTE: Deletes were rolled back by the DBMS software.

Thanks,

Elliot


SAS PremiumReporting - Testen Sie unsere Reportinglosung mit Ihrer personlichen 
Online-Demo
Gleich anmelden unter www.premiumreporting.de


SAS Institute GmbH, In der Neckarhelle 162, 69118 Heidelberg
Registergericht: Mannheim HRB-Nr. 332269, Geschaftsfuhrer: Mikael Hagstrom