How Can we permanently define user-defined variable for a client in MySQL?

In MySQL, it is not possible that a client can hold user variable permanently. It is because all the variables for a given client connection are automatically freed when that client exits.

Anvi Jain

Published on 20-Feb-2018 07:01:17

• Related Questions & Answers
• In MySQL, why a client cannot use a user-defined variable defined by another client?
• How can we store a value in user-defined variable?
• Select into a user-defined variable with MySQL
• Perform MySQL SELECT INTO user-defined variable
• MySQL ORDER BY with numeric user-defined variable?
• How to display grant defined for a MySQL user?
• How can we delete an existing MySQL event permanently?
• Set user-defined variable with table name in MySQL prepare statement?
• Can we use the word user for a MySQL table?
• How to set different auto-increment ids for two tables with a user-defined variable?
• Updating a MySQL table row column by appending a value from user defined variable?
• How can we use SET statement to assign a SELECT result to a MySQL user variable?
• How can we grant privileges to a MySQL user?
• How can we revoke privileges from a MySQL user?
• Using User-Defined Variables in MySQL