How to change the character set of mysql table
- coldplay.xixiOriginal
- 2020-10-09 15:37:5512437browse
Mysql method to change 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. Check the character set of each field in the table.
Mysql method to change the character set of the table:
--Modify 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;
Related free learning recommendations: mysql database (video)
The above is the detailed content of How to change the character set of mysql table. For more information, please follow other related articles on the PHP Chinese website!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：How to input datetime data in mysqlNext article：How to input datetime data in mysql