ONE SHOT option in Mysql

Murali · #1 (**permalink**) 12-13-2007, 05:00 AM

ONE_SHOT

This option is a modifier, not a variable. It can be used to influence the effect of variables that set the character set, the collation, and the time zone.

ONE_SHOT is primarily used for replication purposes: mysqlbinlog uses SET ONE_SHOT to modify temporarily the values of character set, collation, and time zone variables to reflect at rollforward what they were originally.

ONE_SHOT is for internal use only and is deprecated for MySQL 5.0 and up.

You cannot use ONE_SHOT with other than the allowed set of variables; if you try, you get an error like this:

Code:

mysql> SET ONE_SHOT max_allowed_packet = 1;
ERROR 1382 (HY000): The 'SET ONE_SHOT' syntax is reserved for purposes
internal to the MySQL server

If ONE_SHOT is used with the allowed variables, it changes the variables as requested, but only for the next non-SET statement. After that, the server resets all character set, collation, and time zone-related system variables to their previous values. Example:

Code:

mysql> SET ONE_SHOT character_set_connection = latin5;

mysql> SET ONE_SHOT collation_connection = latin5_turkish_ci;

mysql> SHOW VARIABLES LIKE '%_connection';
+--------------------------+-------------------+
| Variable_name            | Value             |
+--------------------------+-------------------+
| character_set_connection | latin5            |
| collation_connection     | latin5_turkish_ci |
+--------------------------+-------------------+

mysql> SHOW VARIABLES LIKE '%_connection';
+--------------------------+-------------------+
| Variable_name            | Value             |
+--------------------------+-------------------+
| character_set_connection | latin1            |
| collation_connection     | latin1_swedish_ci |
+--------------------------+-------------------+

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Export to Excel option is not working in Crystal Report with service pack 2	tsureshk	ASP and ASP.NET Programming	1	10-06-2007 03:57 AM
RightClick option for menu in Flash	bluesky	Flash Actionscript Programming	2	08-14-2007 12:16 AM
double clicking the option in drop down list menu	vijayanand	HTML, CSS and Javascript Coding Techniques	3	08-06-2007 07:27 AM
How to disable right click option?	Sabari	HTML, CSS and Javascript Coding Techniques	1	07-23-2007 10:55 PM
"Which is the better option Servlet's HttpSession object..	mobilegeek	Java Programming	1	07-19-2007 01:08 AM