Shulou(Shulou.com)06/01 Report--

Mysql setting the method of inserting Chinese non-garbled code? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql sets the method of inserting Chinese non-garbled codes: first specify [set names latin1;] in the SQL file, and then import it through the MySQL command with the code [[root@localhost ~] # mysql-uroot-p123456 test set names latin1;mysql > source test.sql

Method 2:

Specify set names latin1; in the SQL file, then log in to MySQL and execute the corresponding file

[root@localhost ~] # cat test.sql set names latin1;insert *; mysql > source test.sql

Method 3:

Specify set names latin1; in the SQL file and import it through the MySQL command

[root@localhost] # mysql-uroot-p123456 test

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.