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

This article mainly introduces mysql how to modify the character set of the table, the article introduces in great detail, has a certain reference value, interested friends must read it!

Mysql changes the character set of the table: 1, modify the encoding of the table to utf8, the code is [alter table store_warehouse convert to character set utf8;]; 2, view the character set of each field in the table.

The method of mysql changing the character set of the table:

-- change the encoding of the table to utf8

Alter table store_warehouse convert to character set utf8

-- View the character set of each field in the table

Show full fields from store_warehouse; above is how mysql modifies all the contents of the character set of the table. 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.