1FLUSH STATUS; 2SHOW local STATUS LIKE 'com_select'; 3Variable_name Value 4Com_select 10 5SHOW local STATUS LIKE 'com_select'; 6Variable_name Value 7Com_select 0 8# Test if charset changes after reset (utf8) 9connect utf8_conn,localhost,root,,,,,CHARSET=utf8; 10connection utf8_conn; 11SELECT IF(@@character_set_client='utf8','OK', 'FAIL') AS RESULT; 12RESULT 13OK 14SELECT IF(@@character_set_client='utf8','OK', 'FAIL') AS RESULT; 15RESULT 16OK 17disconnect utf8_conn; 18# Test if charset changes after reset (latin1) 19connect latin1_conn,localhost,root,,,,,CHARSET=latin1; 20connection latin1_conn; 21SELECT IF(@@character_set_client='latin1','OK', 'FAIL') AS RESULT; 22RESULT 23OK 24SELECT IF(@@character_set_client='latin1','OK', 'FAIL') AS RESULT; 25RESULT 26OK 27disconnect latin1_conn; 28