1. | Variables can be assigned values from arbitrary expressions. | | |
2. | Using variable the calculate the new column ID | | |
3. | Global System Variables versus System Variables at the Connection Level | | |
4. | Returns all global variables and their settings | | |
5. | Return the session system variables | | |
6. | If you're retrieving the value of a global variable, you must also precede the variable name with the global keyword | | |
7. | If you want to retrieve a value for a session variable, rather than a global variable | | |
8. | Set the query_cache_limit variable to 1000000 at the global level | | |
9. | To set a session-level variable | | |
10. | Check the state of the variables with the following command: | | |
11. | Ordinary variables indicated by a prefixed @ sign. | | |
12. | System and server variables: Such variables contain states or attributes of the MySQL server. | | |
13. | Variable Assignment | | |
14. | Use of Variables | | |
15. | SQL variables hold single values. | | |
16. | If the variable has not been used previously, that value is NULL: | | |
17. | To set a variable explicitly to a particular value, use a SET statement. | | |
18. | Variable names are case sensitive: | | |
19. | SQL variables may be used to store the results of intermediate calculations. | | |
20. | Use a two-stage approach involving one query that selects the maximum size into a SQL variable, and another th | | |
21. | Calculate the overall average and save it in a variable, then compare each driver's average to the saved value | | |
22. | To use a SQL variable, store the highest price in it, then use the variable to identify the record containing | | |
23. | To find a value and save it in a variable | | |
24. | SELECT statement defines two variables | | |
25. | User Variables | | |
26. | Set a variable specifically. | | |
27. | Create the user variable PLAYERNO and initialize it with the value 7. | | |
28. | Can the result of a SELECT statement be assigned to a user variable | | |
29. | Compare decimal type variables | | |
30. | Create and set MySQL variable | | |
31. | Using concat to create value for variable | | |
32. | Using variable in where clause | | |
33. | Assin constant value to a variable | | |
34. | Assign the result from a sql to a variable | | |
35. | Assign a constant to a variable | | |
36. | Assign and create three variables inside one select statement | | |
37. | Assign the result of an aggregate function to a variable | | |
38. | Using variable to pass value between sql statement | | |
39. | Compare to a variable | | |
40. | Insert statement with variable | | |
41. | Assign value to a variable with := | | |
42. | Using select ... into to assign value to variabls | | |
43. | A two-query approach | | |
44. | Advancing the rank only when values change | | |
45. | Use the differential as follows to produce team standings that include winning percentage and GB values | | |
46. | To calculate a standard deviation based on n-1 degrees of freedom instead | | |
47. | Calculating Linear Regressions or Correlation Coefficients | | |
48. | Assigning Ranks | | |
49. | Comparing a Table to Itself | | |