Questions about SQL_BUFFER_RESULT

[lcs01]

I am relatively new to mysql.

My questions are:

1) How to set SQL_BUFFER_RESULT's value?
2) How to check its value? I tried something like:

SHOW VARIABLES LIKE '%BUFFER%';

It did not give me what I was looking for.

Thanks for you help.

 

[lcs01]

I know how to set it up now.

mysql> set SQL_BUFFER_RESULT=1;
Query OK, 0 rows affected (0.00 sec)

or

mysql> set sql_buffer_result=0;
Query OK, 0 rows affected (0.00 sec)

Note that it is case insensitive.

But I still don't know how to check its value.

Can someone help?

 

[TonyGroves]

You can use:
[tt]
SELECT @@sql_buffer_result
[/tt]

 

[lcs01]

Thank you. I actually saw this on the web. But I thought it was a typo -- I did not realize '@@' could have meant something.

Thanks again.