Documentation about setting SQL Mode in MySQL incomplete

Issue #1552 resolved
Former user created an issue

The documentation of the SQL Mode setting in MySQL states that to change the SQL Mode without modifying the global server settings, one should create a pool listener to do this automatically when connecting.

There is a much easyer method however, mysql://localhost/test could easily be replaced with mysql://localhost/test?sql_mode=ANSI_QUOTES or something like that which has been supported by MySQLdb for quite some time already.

Perhaps this should be noted in the docs before telling someone to go through the steps of creating a pool listener?

Comments (4)

  1. Mike Bayer repo owner

    all of this verbiage is long out of date since 0.6 as the whole ANSI QUOTES thing is automatic and there's otherwise no special information about sql_mode needed. Since we've had the wrong docs up on the site in this regard for years now, I've replaced it with a paragraph that states there's nothing really do be done in this regard along with an 0.6 note, in 2cea98dfc511abd569adff2deba3e6d0d0760f3e, 37579440510649181276556536c5da766eafc904, 3c64564b984544faf8b19407010a8891a825240e for 0.6, 0.7, default.

  2. Log in to comment