GNU Info

(mysql.info)ANSI mode

---

Next: Missing functions Prev: Differences from ANSI Up: Compatibility

---

Enter node , (file) or (file)node

Running MySQL in ANSI Mode
--------------------------

If you start `mysqld' with the `--ansi' option, the following behavior
of MySQL changes:

   * `||' is string concatenation instead of `OR'.

   * You can have any number of spaces between a function name and the
     `('.  This forces all function names to be treated as reserved
     words.

   * `"' will be an identifier quote character (like the MySQL ``'
     quote character) and not a string quote character.

   * `REAL' will be a synonym for `FLOAT' instead of a synonym of
     `DOUBLE'.

   * The default transaction isolation level is `SERIALIZABLE'.  Note:
     SET TRANSACTION.

This is the same as using
`--sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,SERIALIZE,ONLY_FULL_GROUP_BY'.