In another question I posted someone told me that there is a difference between: @variable and: variable in MySQL. He also mentioned how MSSQL has batch scope and MySQL has session scope. Can som...

First, I set John to the user-defined variable @name as shown below: SET @name = 'John'; Then, I set David to @name in a transaction, then rollbacked as shown below: BEGIN; SET @name = 'David'; RO...

I use the following query in my trigger to store user's ID for further use: SELECT set_config('session.my_username', 'john', false); Later, in other trigger I use it this way: SELECT current_setti...