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 Received on Mon Jun 25 08:40:00 2007

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek