/usr/sbin/mysqld, Version: 5.0.67-community-log (MySQL Community Edition (GPL)). started with: Tcp port: 3307 Unix socket: (null) Time Id Command Argument 090320 14:04:09 1 Connect webapp@chris.indeed.com on chris 1 Query /* mysql-connector-java-5.1.7 ( Revision: ${svn.Revision} ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'init_connect' 1 Query /* mysql-connector-java-5.1.7 ( Revision: ${svn.Revision} ) */SELECT @@session.auto_increment_increment 1 Query SHOW COLLATION 1 Query SET NAMES latin1 1 Query SET character_set_results = NULL 1 Query SET autocommit=1 1 Query SET sql_mode='STRICT_TRANS_TABLES' 1 Query DROP TABLE IF EXISTS testtable_bincolumn 1 Query CREATE TABLE testtable_bincolumn (bincolumn binary(8) NOT NULL, PRIMARY KEY (bincolumn)) ENGINE=InnoDB 1 Query INSERT INTO testtable_bincolumn (bincolumn) VALUES (unhex('0123456789ABCD90')), (unhex('0123456789ABCD00')) 1 Query SELECT * FROM testtable_bincolumn WHERE bincolumn = unhex('0123456789ABCD90') 1 Query SHOW KEYS FROM `testtable_bincolumn` FROM `chris` 1 Query DELETE FROM `chris`.`testtable_bincolumn` WHERE `chris`.`testtable_bincolumn`.`bincolumn`<=>'#Eg‰«Íť' 1 Query SELECT * FROM testtable_bincolumn WHERE bincolumn = unhex('0123456789ABCD90') 1 Query SELECT * FROM testtable_bincolumn WHERE bincolumn = unhex('0123456789ABCD00') 1 Query SHOW KEYS FROM `testtable_bincolumn` FROM `chris` 1 Query DELETE FROM `chris`.`testtable_bincolumn` WHERE `chris`.`testtable_bincolumn`.`bincolumn`<=>'#Eg‰«Í\0' 090320 14:04:10 1 Query SELECT * FROM testtable_bincolumn WHERE bincolumn = unhex('0123456789ABCD00') 1 Quit