Display Variable And Values Oracle MySQL
Variables are values that control the operation of oracle and mysql database. Here is the simple command to disply variables and its associated values
In Oracle database,
show parameter parametername;
In MySQL environment,
The above command will display all the variables that has auto as a part of its name
mysql> show variables like 'auto%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
+--------------------------+-------+
4 rows in set (0.00 sec)
Note that the above session variables in mysql are equivalent to init.ora parameters in Oracle
