Shulou(Shulou.com)05/31 Report--

This article will explain in detail the methods of viewing and setting commands for mysql codes. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

-- the character set viewed

Show variables like 'character\ _ set\ _%'

Show variables like 'collation_%'

-- set the database character encoding

Set names' GBK'

Alter database payment character set GBK

Create database mydb character set GBK

Set character_set_client=gbk

Set character_set_connection=gbk

Set character_set_database=gbk

Set character_set_results=gbk

Set character_set_server=gbk

Set character_set_system=gbk

Set collation_connection=gbk

Set collation_database=gbk

Set collation_server=gbk

This is the end of this article on "mysql code viewing and setting commands". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.