Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysql修改编码_MySQL

mysql修改编码_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-01 13:28:15
Original
879 people have browsed it

bitsCN.com

  • 修改表编码
  • ALTER TABLE  `uc_users_bak` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
  • #检查数据表所有字段的状态
  • ->show full columns from phplamp;
  • #发现address字段的Collation项非utf8，修改它！
  • ->alter table phplamp change name name varchar(100) character set utf8 collate utf8_unicode_ci not null default '';
bitsCN.com
Related labels：
mysql
source：php.cn
Previous article：Ubuntu 12.04 LTS 构建高可用 MySQL 集群_MySQL Next article：mysql执行计划介绍_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
The problem that mysql service cannot be restarted after mysql upgrade
From 1970-01-01 08:00:00
0
0
0
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
php - In wamp, how to use mysql installed by myself instead of wamp integrated mysql?
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template