mysql更改數(shù)據(jù)庫字符編碼的方法:首先調(diào)出“運(yùn)行”,輸入cmd;然后登錄數(shù)據(jù)庫,查看數(shù)據(jù)庫;最后修改數(shù)據(jù)庫的字符集,代碼為【mysql>use mydb】。
相關(guān)免費(fèi)學(xué)習(xí):mysql數(shù)據(jù)庫(視頻)
mysql更改數(shù)據(jù)庫字符編碼的方法:
1、win+R,調(diào)出“運(yùn)行”,輸入cmd,回車
2、mysql 更改數(shù)據(jù)庫字符編碼的方法
登錄數(shù)據(jù)庫,
3、查看數(shù)據(jù)庫
4、查看數(shù)據(jù)庫字符編碼
5、通過MySQL命令行修改:(編碼可選)
mysql> set character_set_client=utf8; mysql> set character_set_connection=utf8; mysql> set character_set_database=utf8; mysql> set character_set_results=utf8; mysql> set character_set_server=utf8; mysql> set character_set_system=utf8; mysql> set collation_connection=utf8; mysql> set collation_database=utf8; mysql> set collation_server=utf8;
6、當(dāng)然還有:
修改數(shù)據(jù)庫的字符集mysql>use mydb
mysql>alter database mydb character set utf8;
7、創(chuàng)建數(shù)據(jù)庫指定數(shù)據(jù)庫的字符集
mysql>create database mydb character set utf8;