Setting Variables

Setting Variables

The SET statement is used to set the value of server variables ”the same variables we could see via the show variables statement in the preceding section. This statement uses the syntax

 set  variable  =  value  ; 

For example, we might use:

 set sql_safe_updates=1; 

This turns on safe updates (as we can at the command line with - “i-am-a- dummy ).

We will make good use of this statement when we come to server optimization in Chapter 17, "Optimizing Your MySQL Server Configuration."