Usage Note 30825: Deleting Rows from a MySQL table in SAS/ACCESS® Interface to MySQL
Using SAS/ACCESS Interface to MySQL LIBNAME and PROC SQL to delete rows from a MySQL table can return the following error:
libname my mysql database=test port=3306 server='grouper' user=dbitest pwd=dbigrp1;
data my.class;
set sashelp.class;
run;
proc sql;
delete from my.class
where name eq 'Janet';
quit;
ERROR: Execute error: 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 '' at line 1
ERROR: ROLLBACK issued due to errors for data set MY.class.DATA.
>
To delete rows from a MySQL table, the table must have a Primary Key.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to MySQL | Microsoft® Windows® for x64 | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |
| Windows Vista | 9.1 TS1M3 SP4 | |
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |
| Linux | 9.1 TS1M3 SP4 | |
| Linux on Itanium | 9.1 TS1M3 SP4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2008-05-29 15:22:12 |
| Date Created: | 2007-12-19 15:22:55 |