Coding problems with MySQL data import and free sqlyog8.6 registration code sharing

Problems with importing access data from MYSQL:

 

1. The encoding varies with MySQL clients.

It is best to install several more clients, such as MySQL-front, sqlyog, navicat, and MySQL GUI tool. Each has its own advantages. If you only install one package, many things are complicated to implement and use tools to save trouble!

For example, when importing data from sqlyog, navicat queries may encounter garbled characters.

2. sqlyog Enterprise Edition has no import function. The latest sqlyog version has powerful functions.

 

3. Change Encoding settings

Show Variables Like   'Char %' # Query the encoding format Set   Names   'Gbk' ; # Set the encoding format Alter   Database Datasir Set Charset = 'Gbk' ;Set Character_set_client = 'Utf8' ; Set Character_set_connection = 'Utf8' ; Set Character_set_results = 'Utf8' ; Set Character_set_server = 'Utf8' ; Set Character_set_system = 'Utf8' ; Set Character_set_results = 'Utf8' ;-------------------------------------- -- Show Create  Table IP address; # view the table structure code

 
4. Free sqlyog8.6 registration code:
 

 
26f359fc-e3f6-4727-8af1-72a1a4a0819d