Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.4Mb
PDF (A4) - 37.5Mb
PDF (RPM) - 33.2Mb
HTML Download (TGZ) - 8.3Mb
HTML Download (Zip) - 8.4Mb
HTML Download (RPM) - 7.3Mb
Man Pages (TGZ) - 129.8Kb
Man Pages (Zip) - 185.4Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb


Pre-General Availability Draft: 2018-02-23

13.7.5 SET Syntax

The SET statement has several forms. Descriptions for those forms that are not associated with a specific server capability appear in subsections of this section:

Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement:


User Comments
  Posted by George Marshall on June 14, 2014
When using the multiple variable assignment syntax, none of the assignments can depend on the results of the other assignments. For example, the variable @d will not be assigned a value:

set @c=1, @d=@c+1;
select @c, @d; # @d will be null
Sign Up Login You must be logged in to post a comment.