content_image/852884.jpg content_image/852885.jpg content_image/852886.jpg
<img src='content_image/852884.jpg'>

This variable controls whether updates to a view can be made when the view does not contain all columns of the primary key defined in the underlying table, if the update statement contains a LIMIT clause. (Such updates often are generated by GUI tools.) An update is an UPDATE  or DELETE  statement. Primary key here means a PRIMARY KEY , or a UNIQUE  index in which no column can contain NULL . 

The variable can have two values: 

• 1  or YES : Issue a warning only (not an error message). This is the default value. 

• 0  or NO : Prohibit the update. 

• use_secondary_engine 

<img src='content_image/852885.jpg'>

For future use. 

Whether to execute queries using a secondary engine. 

For use with HeatWave. See HeatWave User Guide. 

• validate_password. xxx 

The validate_password  component implements a set of system variables having names of the form validate_password. xxx . These variables affect password testing by that component; see Section 6.4.3.2, “Password Validation Options and Variables” . 

• version 

The version number for the server. The value might also include a suffix indicating server build or configuration information. -debug  indicates that the server was built with debugging support enabled. 

• version_comment 

<img src='content_image/852886.jpg'>

