LispWorks User Guide and Reference Manual > 19 Common SQL > 19.9 Using MySQL

NextPrevUpTopContentsIndex

19.9.4 SQL mode

Because Common SQL is geared towards ANSI SQL, by default it connects in ANSI mode. If another mode is required, it can be set at connection time.

For example, to make MySQL treat quotes as in ANSI without setting other ANSI features, do:

(sql:connect "me/mypassword/mydb"
             :sql-mode "ANSI_QUOTES")

See the description of the :sql-mode argument to connect for details.


LispWorks User Guide and Reference Manual - 22 Dec 2009

NextPrevUpTopContentsIndex