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

This article mainly introduces how to query the mysql code, the article is very detailed, has a certain reference value, interested friends must read it!

Query mysql coding method: 1, use the "show variables like 'character_set_database';" statement, you can view the database encoding format; 2, use the "show create table data table name;" statement, you can view the data table coding.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

View mysql database and table encoding format

1. View the database encoding format

Mysql > show variables like 'character_set_database'

2. View the encoding format of the data table

Mysql > show create table

Extended knowledge: modify coding format

1. Modify the coding format of the database

Mysql > alter database character set utf8

2. Modify the data table coding format

Mysql > alter table character set utf8

3. Modify the field coding format

Mysql > alter table change character set utf8;mysql > alter table user change username username varchar (20) character set utf8 not null; is all the contents of this article "how to query mysql codes". 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.