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