At 10:23 -0600 3/25/05, Stembridge, Michael wrote:
While I was RTFM to find out how long SET variables last, I noticed that my
book uses @@VarName but the sample code I'm using has @ VarName. I didn't
see a reference to the single @ in the SET section of my book.
So, what is the difference between @@ and @?
@ is used for user variables (variables that you define yourself)
@@ is used for system variables, such as storage_engine or sql_mode.
http://dev.mysql.com/doc/mysql/en/set-option.html
http://dev.mysql.com/doc/mysql/en/variables.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]