Monday, March 12, 2012

SET variable (user defined) in mysql returns NULL (MySQL Browser)

Source: MySQL bug Forum
Steps
1. Open MySQL Browser
2. Click Tools menu
3. Click Options
4. Choose Browser
5. Check Show Advanced Toolbars
6. Click Apply
7. Click close
8. Transactions Toolbar appears on MySQL Browser
9. Click the Transaction button on the transaction toolbar everytime
you execute the query
Sample query:
Set @names = 'james';
select @names;

0 comments:

Post a Comment