mysql如何查看数据库编码
程序员文章站
2022-06-13 14:17:23
...
本文内容:本文介绍了在控制台下,使用命令的方式查看mysql数据库的编码。
1.首先连接数据库。
在cmd下输入
>mysql -h 数据库地址 -u 用户名 -p密码
2.连接数据库完成后
使用 status 命令查看数据库的编码方式:
mysql> status; -------------- C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe Ver 14.14 Distrib 5.6.21, for Win32 (x86) Connection id: 1320 Current database: Current user: rdps@10.118.44.29 SSL: Not in use Using delimiter: ; Server version: 5.5.28 MySQL Community Server (GPL) Protocol version: 10 Connection: 10.118.46.4 via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: gbk Conn. characterset: gbk TCP port: 3306 Uptime: 2 days 1 hour 28 min 49 sec Threads: 10 Questions: 680380 Slow queries: 0 Opens: 167265 Flush tables: 2 Open tables: 4 Queries per second avg: 3.819 --------------
如果想看某一个数据库的编码方式,首先要用use 数据库名切换数据库。不知道有哪些数据库,可以使用show databases;
或者使用
<span style="font-size:14px;">mysql> show variables like 'char%'; +--------------------------+---------------------------------------------------- ---+ | Variable_name | Value | +--------------------------+---------------------------------------------------- ---+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/local/mysql-5.5.28-linux2.6-i686/share/charset s/ | +--------------------------+---------------------------------------------------- ---+ 8 rows in set (0.00 sec)</span>
更多相关教程请访问 MySQL视频教程
下一篇: js仿jquery步骤详解