Hi Samit,
mysql> select @toto
    -> ;
+-------+
| @toto |
+-------+
| NULL  |
+-------+
1 row in set (0.00 sec)

mysql> set @toto:=5;
Query OK, 0 rows affected (0.01 sec)

...
use @toto
...

mysql> set @toto:=NULL;
Query OK, 0 rows affected (0.00 sec)

mysql> select @toto;
+-------+
| @toto |
+-------+
| NULL  |
+-------+
1 row in set (0.00 sec)





Selon samit jain <[EMAIL PROTECTED]>:

> Hi,
>
> A simple question. How to delete the user variables
> created on the server using set @varname=<expr>
> syntax?
>
> thanks,
>
> Samit
>
>
>
> __________________________________
> Discover Yahoo!
> Stay in touch with email, IM, photo sharing and more. Check it out!
> http://discover.yahoo.com/stayintouch.html
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to