You can set the default SQL mode (for mysqld startup) in the MySQL configuration with the --sql-mode option. With SET [SESSION|GLOBAL] sql_mode='modes' you can change the settings from within a connection; either local to the connection, or to take effect globally. You can retrieve the current mode by issuing a SELECT @@sql_mode statement.