2. 3 Query/* mysql connector - Java - 5.1.15 (Revision: ${.bzr. Revision - id}) */SHOW the 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_server' OR 'character_set' Variable_name 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=
='lower_case_table_names' OR' system_time_zone 'Variable_name OR Variable_name=' max_allowed_packet 'OR Variable_name=
='sql_mode' OR 'net_buffer_length' Variable_name OR Variable_name='query_cache_type' OR Variable_name='query_cache_size' OR
Variable_name='init_connect'
, 110602 12:55:21 3 Query/* mysql connector - Java - 5.1.15 (Revision: ${.bzr. Revision - id}) */SELECT
@ @ session. Auto_increment_increment
, 3 Query SET NAMES utf8mb4
5. 3 Query SET character_set_results=NULL
6. 3 Query SET the autocommit mode=1
7. 3 Query select * from the user where the username='asdasd' and password='aa'
, 3 Quit
could you please tell me, first step is to connect to the database, steps 2 through 6 what meaning be? Step 7 is the query; Step 8 is out! Help: who knows what steps 2 through 6 mean?
CodePudding user response:
Log in the first step of root @ behind if the IP address of the replaced by a foreign representative what mean, the operation of the IP address database of IP?CodePudding user response:
Second, display system of these variables
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
Value | | Variable_name |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
GBK | character_set_client | |
GBK | character_set_connection | |
GBK | character_set_results | |
| character_set_server | utf8 |
| init_connect | |
28800 | | interactive_timeout |
| | lower_case_table_names | 1
4194304 | | max_allowed_packet |
16384 | | net_buffer_length |
60 | | net_write_timeout |
1048576 | | query_cache_size |
| query_cache_type | OFF |
| sql_mode | NO_AUTO_VALUE_ON_ZERO |
| system_time_zone | |
| time_zone 00:00 | | +
| transaction_isolation | the REPEATABLE - READ |
| tx_isolation | the REPEATABLE - READ |
28800 | | wait_timeout |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
18 rows in the set, 1 warning (0.58 SEC)
Article 3: the SELECT @ @ session. Auto_increment_increment;
Check the primary key step on the long
Article 4: sets the character set at the server side utf8mb4
Article 5: set the character set character_set_results empty
Article 6: set up the transaction is automatically submit (note: 0 means manual submitted, which USES the MySQL client transactions executed after the SQL command commit command must be used, otherwise the execution of the SQL command is invalid, if you want to cancel the transaction, use the rollback command automatically submit 1 said, namely in MySQL client not need to manually perform a commit command,)