MySQL

The MySQL back-end requires the MySQL C client library (libmysqlclient.so). The location of this library is specified via *mysql-so-load-path*, which defaults to /usr/lib/libmysqlclient.so. Additional flags to ld needed for linking are specified via *mysql-so-libraries*, which defaults to ("-lc").

Use

(asdf:operate 'asdf:load-op 'clsql-mysql)
	

to load the MySQL back-end. The database type for the MySQL back-end is :mysql.

  • drop-index requires a table to be specified with the :on keyword parameter.

  • views are not supported by MySQL.

  • The :transactions keyword argument to create-table controls whether or not the created table is an InnoDB table which supports transactions.

  • The :owner keyword argument to the FDDL functions for listing and testing for database objects is ignored.