java learnging

一块探讨JAVA的奥妙吧

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

mysql常用操作

Posted on 2005-07-25 17:38 bigseal 阅读(1431) 评论(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;