Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 33.8Mb
PDF (A4) - 33.8Mb
PDF (RPM) - 31.8Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 145.9Kb
Man Pages (Zip) - 206.8Kb
Info (Gzip) - 3.1Mb
Info (Zip) - 3.1Mb


Pre-General Availability Draft: 2017-11-22

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.