java learnging

一塊探討JAVA的奧妙吧

posts - 34, comments - 27, trackbacks - 0, articles - 22

mysql常用操作

Posted on 2005-07-25 17:38 bigseal 閱讀(1437) 評論(0) 編輯收藏

修改默認字符集（default character set）
在mysql的my.ini配置文件中設置，這樣在mysql啟動后就會自動加載
例如：把默認字符集設置為UTF-8

default-character-set=utf8

查看變量值：
例如：查看字符集設置

SHOW VARIABLES LIKE 'character_set_%';

SHOW VARIABLES LIKE 'collation_%';

設置變量值
例如：設置字符集變量

set character_set_server = utf8;

set character_set_system = utf8;

set character_set_database = utf8;

set character_set_client = utf8;

set character_set_connection = utf8;

set character_set_results = utf8;

set collation_connection = utf8_general_ci;

set collation_database = utf8_general_ci;

set collation_server = utf8_general_ci;