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

This article mainly explains "how to configure MySQL parameters". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to configure MySQL parameters.

SQL_MODE

Configure how MySQL handles SQL

Character parameter

Chinese garbled code

Mysql > SELECT course,AVG (score) FROM score GROUP BY course +-+-+ | course | AVG (score) | +-+-+ | 70.0000 | | 74.5000 | | 88.0000 | | 35.0000 | | 80.0000 | | 30.0000 | | | 40.0000 | |? | 70.0000 | +-+-+ 8 rows in set (70.0000 semysql > show variables like 'character%') | +-- +-- + | Variable_name | Value | +-- -+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | / usr/share/mysql/charsets/ | +-- +-- + 8 rows in set (0.00 sec) mysql > set character_set_database=utf8 | Query OK, 0 rows affected, 1 warning (0.00 sec) mysql > set character_set_server=utf8;Query OK, 0 rows affected (0.00 sec) temporary modification-set [global] variable_name=charset;mysql > set global character_set_server=utf8; permanent modification

Specify in the my.cnf file

Influence parameters:

Character_set_client

Character_set_connection

Character_set_results

Influence parameters:

Character_set_database

Character_set_server

Thank you for your reading, the above is the content of "how to configure MySQL parameters". After the study of this article, I believe you have a deeper understanding of how to configure MySQL parameters, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.