20140509-mysql Import script file, display garbled solution when inserting data

20140509-mysql Import script file, display garbled solution when inserting data

Open CMD Enter the following command:

Mysql–u root–p

Then enter the password:

Before importing a script file, set the character encoding:

CharSet GBK;

Note: The above statement is very critical so that no matter where you cmd window, or using the client input Chinese, can be saved correctly.

Beginners are advised not to use the Span style= "Font-family:times New Roman;" >sqlyog navicat Premium etc Client Connection tool.