SET OPTION SQL_OPTION=
Defines an option for the current session. Values set by this statement are not in effect anywhere but the current connection, and they disappear at the end of the connection. The following options are currently supported:
AUTOCOMMIT=0 or 1
When set to the default value of 1, each statement sent to the
database is automatically committed unless preceded by
BEGIN. Otherwise, you need to send a
ROLLBACK to end a
Changes the character set used by
DEFAULT will return to the
original character set.
Determines the value returned from
LAST_INSERT_ID( ) function.
Sets the password for the current user.
PASSWORD FOR user = PASSWORD('password')
Sets the password for the specified user.
SQL_AUTO_IS_NULL= 0 or 1
When set to the default value of 1, you can find the last inserted
row in a table with
SQL_BIG_SELECTS=0 or 1
Determines the behavior when a large
SELECT query is encountered. If set to 1, MySQL
will abort the query with an error, if the query would probably take
too long to compute. MySQL decides that a query will take too long if
it will have to examine more rows than the value of the
max_join_size server variable. The default value
of the variable is 0, which allows all queries.
SQL_BIG_TABLES=0 or 1
Determines the behavior of temporary tables (usually ...