Go to the first, previous, next, last section, table of contents.
SET [OPTION] SQL_VALUE_OPTION=value, ...
The used options remain in effect for the whole current session.
The different options are:
SQL_SELECT_LIMIT=value
-
The maximum number of records to return in any select.
If a select has a limit clause it overrides this statement.
The default value for a new connection is 'unlimited'.
SQL_BIG_TABLES= 0 | 1
-
If set to 1 then all temporary tables are stored on disk instead of in memory.
This will be a little slower, but one will not get the error
The table ### is full for big selects that require a big temporary
table. The default value for a new connection is 0 (use in memory
temporary tables).
SQL_BIG_SELECTS= 0 | 1
-
If set to 1 then MySQL will abort if a select is attempted that will
probably take a very long time. This is useful when an erroneous
WHERE
statement has been issued. A big query is defined as a SELECT that
will probably have to examine more than max_join_size rows. The
default value for a new connection is 0 (which will allow all SELECT's).
CHARACTER SET character_set_name | DEFAULT
-
This maps all strings from and to the client with the given mapping.
Currently the only option for character_set_name is
cp1251_koi8,
but one can easily add new mappings by editing the file
mysql_source_directory/sql/convert.cc.
One can restore the default mapping by using DEFAULT as the
character_set_name.
SQL_LOG_OFF= 0 | 1
-
If set to 1 then no logging will done to the standard log for this
client if the client has process list privileges. This doesn't affect
the update log!
TIMESTAMP= timestamp_value | DEFAULT
-
Set the time for this client. This is used to get the original timestamp if
one uses the update log to restore rows.
LAST_INSERT_ID= #
-
Set the value to be returned from LAST_INSERT_ID(). This is stored in the
update log when one uses LAST_INSERT_ID() in a command that updates a table.
Go to the first, previous, next, last section, table of contents.