In MySQL, why a client cannot use a user-defined variable defined by another client?

In MySQL, a user-defined variable defined by one client cannot be seen or used by another client because user-defined variables are connection-specific. It means that all variables for a given client connection are automatically freed when that client exits

Sreemaha

Published on 20-Feb-2018 06:58:18

• Related Questions & Answers
• How Can we permanently define user-defined variable for a client in MySQL?
• MySQL ORDER BY with numeric user-defined variable?
• Select into a user-defined variable with MySQL
• Perform MySQL SELECT INTO user-defined variable
• Updating a MySQL table row column by appending a value from user defined variable?
• How can we store a value in user-defined variable?
• Set custom messages by working with MySQL IF Statements and SELECT in a user-defined variable
• Using User-Defined Variables in MySQL
• Set user-defined variable with table name in MySQL prepare statement?
• PHP User-defined functions
• How to display grant defined for a MySQL user?
• Get the maximum exam date using a user-defined variable in SQL
• MongoDB query to set user defined variable into query?
• Add user defined value to a column in a MySQL query?
• Increment multiple Timestamp values by setting the incremented value in a user-defined variable in SQL