What is the method for assigning a global variable in SQL?

In SQL, assigning a value to a global variable can be achieved using the SET keyword. For example, a value can be assigned to a global variable using the following syntax:

SET @my_variable = 'value';

In this example, @my_variable is a global variable that can be accessed and utilized within the current session. You can assign values to the global variable multiple times using the SET statement as needed.