To display the mysql system variables and their values -
1. Login to mysql - "mysql -uUSERNAME -p"
2. Type "show variables" to display all the system variables and their values.
3. Type "show variables like 'my_pattern'" to display only a variable(s) matching this pattern.
Example -
"show variables like '%commit%';"
4. Type "select @@autocommit" to display the value of the autocommit variable
1. Login to mysql - "mysql -uUSERNAME -p"
2. Type "show variables" to display all the system variables and their values.
3. Type "show variables like 'my_pattern'" to display only a variable(s) matching this pattern.
Example -
"show variables like '%commit%';"
4. Type "select @@autocommit" to display the value of the autocommit variable
No comments:
Post a Comment