1、110602 12:55:20 3 Connect root@localhost on w2p/
2、 3 Query /* mysql-connector-java-5.1.15 ( Revision: ${bzr.revision-id} ) */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'
3、110602 12:55:21 3 Query /* mysql-connector-java-5.1.15 ( Revision: ${bzr.revision-id} ) */SELECT
@@session.auto_increment_increment
4、 3 Query SET NAMES utf8mb4
5、3 Query SET character_set_results = NULL
6、 3 Query SET autocommit=1
7、 3 Query select * from user where username = 'asdasd' and password = 'aa'
8、3 Quit
请问,第1步是连接数据库,第2步到第6步是什么意思?第7步是查询语句;第8步是退出连接!求助:谁知道第2步到第6步是什么意思?
2、 3 Query /* mysql-connector-java-5.1.15 ( Revision: ${bzr.revision-id} ) */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'
3、110602 12:55:21 3 Query /* mysql-connector-java-5.1.15 ( Revision: ${bzr.revision-id} ) */SELECT
@@session.auto_increment_increment
4、 3 Query SET NAMES utf8mb4
5、3 Query SET character_set_results = NULL
6、 3 Query SET autocommit=1
7、 3 Query select * from user where username = 'asdasd' and password = 'aa'
8、3 Quit
请问,第1步是连接数据库,第2步到第6步是什么意思?第7步是查询语句;第8步是退出连接!求助:谁知道第2步到第6步是什么意思?
| Variable_name | Value |
+--------------------------+-----------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_results | gbk |
| character_set_server | utf8 |
| init_connect | |
| interactive_timeout | 28800 |
| lower_case_table_names | 1 |
| max_allowed_packet | 4194304 |
| net_buffer_length | 16384 |
| net_write_timeout | 60 |
| query_cache_size | 1048576 |
| query_cache_type | OFF |
| sql_mode | NO_AUTO_VALUE_ON_ZERO |
| system_time_zone | |
| time_zone | +00:00 |
| transaction_isolation | REPEATABLE-READ |
| tx_isolation | REPEATABLE-READ |
| wait_timeout | 28800 |
+--------------------------+-----------------------+
18 rows in set, 1 warning (0.58 sec)
第三条:SELECT @@session.auto_increment_increment;
查看主键的自增步长第四条:设置服务器方面的字符集为 utf8mb4第五条:设置此 字符集 character_set_results 为空第六条: 设置事务是自动提交(注:0 表示手动提交,即使用 MySQL 客户端执行 SQL 命令后必须使用commit命令执行事务,否则所执行的 SQL 命令无效,如果想撤销事务则使用 rollback 命令。1 表示自动提交,即在 MySQL 客户端不在需要手动执行 commit 命令。)