Data Set Options for MySQL

All SAS/ACCESS data set options in this table are supported for MySQL. Default values are provided where applicable. For details, see Data Set Options for Relational Databases.

Data Set Options for MySQL
Option	Default Value
BL_DEFAULT_DIR=	temporary file directory that is specified by the UTILLOC= system option
BL_USE_PIPE=	NO
BULKLOAD=	NO
DBCOMMIT=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBGEN_NAME=	DBMS
DBINDEX=	LIBNAME option value
DBKEY=	none
DBLABEL=	NO
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBNULL=	YES
DBPROMPT=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for MySQL
DBTYPE=	see LIBNAME Statement Data Conversions
ESCAPE_BACKSLASH=	NO
INSERTBUFF=	1
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
POST_COLUMN_OPTS=	none
PRESERVE_COL_NAMES=	LIBNAME option value
QUALIFIER=	LIBNAME option value
SASDATEFMT=	DATETIME20.0
UPDATE_ISOLATION_LEVEL=	LIBNAME option value

Last updated: February 3, 2026