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

This article mainly introduces the method of using the command line to set the MySql coding format, the article introduces in great detail, has a certain reference value, interested friends must read!

The way to format MySql encoding using the command line: first log in to mysql and enter [SHOW VARIABLES LIKE 'character_set_%']; then check to see if the value is utf8, and if not, use the SET setting; finally, you can finish.

Use the command line to format the MySql encoding:

1. Log in to mysql

two。 Enter SHOW VARIABLES LIKE 'character_set_%'

3. Check to see if the value value is utf8, and if not, use the SET setting.

4. Type SHOW VARIABLES LIKE 'character_set_%'; to check the confirmation again.

5. Finally, the exit; is completed.

The above is all the content of this article entitled "using the command line to set the MySql encoding format". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.