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

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 11:28:18

Previous Page Print Page