Liunx环境下MySQL字符集的修改方法(1)(3)

mysql> show variables like 'collation_%';  
+----------------------+-----------------+  
| Variable_name        | Value           |  
+----------------------+-----------------+  
| collation_connection | utf8_general_ci |  
| collation_database   | utf8_general_ci |  
| collation_server     | utf8_general_ci |  
+----------------------+-----------------+  
3 rows in set (0.02 sec)  
 
mysql> show variables like 'character_set_%';  
+--------------------------+----------------------------+  
| Variable_name            | Value                      |  
+--------------------------+----------------------------+  
| character_set_client     | utf8                       |  
| character_set_connection | utf8                       |  
| character_set_database   | utf8                       |  
| character_set_filesystem | binary                     |  
| character_set_results    | utf8                       |  
| character_set_server     | utf8                       |  
| character_set_system     | utf8                       |  
| character_sets_dir       | /usr/share/mysql/charsets/ |  
+--------------------------+----------------------------+  
8 rows in set (0.02 sec)  
 
mysql> 
 

MySQL删除外键定义的方法

MySQL外键和参照完整性的联系

带参数的MySql存储过程

PHP中常用到的一些MySQL语句

mysql UPDATE语句的使用方法