Hi


mysql> show /*!50000 global */ status like '%tmp%';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| Created_tmp_disk_tables | 277 |
| Created_tmp_files | 0 |
| Created_tmp_tables | 277 |
+-------------------------+-------+
3 rows in set (0.00 sec)

mysql> show status like '%tmp%';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 0 |
| Created_tmp_tables | 0 |
+-------------------------+-------+

the both statements give the status variable but the value is diff from each statement

can anybody explain why is that


Thanks