乱码图示
+----+------------+------+---------------------+-------------+-------+--------------+
| id | name | sex | borndate | phone | photo | boyfriend_id |
+----+------------+------+---------------------+-------------+-------+--------------+
| 1 | 鏌冲博 | 濂? | 1988-02-03 00:00:00 | 18209876577 | NULL | 8 |
| 2 | 鑻嶈€佸笀 | 濂? | 1987-12-30 00:00:00 | 18219876577 | NULL | 9 |
| 3 | Angelababy | 濂? | 1989-02-03 00:00:00 | 18209876567 | NULL | 3 |
| 4 | 鐑反 | 濂? | 1993-02-03 00:00:00 | 18209876579 | NULL | 2 |
| 5 | 鍛ㄥ啲闆? | 濂? | 1992-02-03 00:00:00 | 18209179577 | NULL | 9 |
| 6 | 鍛ㄨ姺鑻? | 濂? | 1988-02-03 00:00:00 | 18209876577 | NULL | 1 |
| 7 | 宀崇伒鐝? | 濂? | 1987-12-30 00:00:00 | 18219876577 | NULL | 9 |
| 8 | 灏忔槶 | 濂? | 1989-02-03 00:00:00 | 18209876567 | NULL | 1 |
| 9 | 鍙屽効 | 濂? | 1993-02-03 00:00:00 | 18209876579 | NULL | 9 |
| 10 | 鐜嬭瀚? | 濂? | 1992-02-03 00:00:00 | 18209179577 | NULL | 4 |
| 11 | 澶忛洩 | 濂? | 1993-02-03 00:00:00 | 18209876579 | NULL | 9 |
| 12 | 璧垫晱 | 濂? | 1992-02-03 00:00:00 | 18209179577 | NULL | 1 |
| 14 | 鏉ㄧ传 | 濂? | 1993-03-05 00:00:00 | 1352342232 | NULL | 8 |
| 15 | 鍒樿瘲璇? | 濂? | 1987-01-01 00:00:00 | 12345678911 | NULL | NULL |
+----+------------+------+---------------------+-------------+-------+--------------+
很明显中文都乱码了,所以我们得更改字符集的编码,我们可以使用一下命令来查看DOS窗口使用的字符编码
show variables like 'char%';
可见我们的character_set_results的字符集编码为utf-8,我们得更改为gbk
+--------------------------+---------------------------------------------------------+
| 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 | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
更改编码为gbk
set character_set_results = gbk;
完美解决问题
+----+------------+------+---------------------+-------------+-------+--------------+
| id | name | sex | borndate | phone | photo | boyfriend_id |
+----+------------+------+---------------------+-------------+-------+--------------+
| 1 | 柳岩 | 女 | 1988-02-03 00:00:00 | 18209876577 | NULL | 8 |
| 2 | 苍老师 | 女 | 1987-12-30 00:00:00 | 18219876577 | NULL | 9 |
| 3 | Angelababy | 女 | 1989-02-03 00:00:00 | 18209876567 | NULL | 3 |
| 4 | 热巴 | 女 | 1993-02-03 00:00:00 | 18209876579 | NULL | 2 |
| 5 | 周冬雨 | 女 | 1992-02-03 00:00:00 | 18209179577 | NULL | 9 |
| 6 | 周芷若 | 女 | 1988-02-03 00:00:00 | 18209876577 | NULL | 1 |
| 7 | 岳灵珊 | 女 | 1987-12-30 00:00:00 | 18219876577 | NULL | 9 |
| 8 | 小昭 | 女 | 1989-02-03 00:00:00 | 18209876567 | NULL | 1 |
| 9 | 双儿 | 女 | 1993-02-03 00:00:00 | 18209876579 | NULL | 9 |
| 10 | 王语嫣 | 女 | 1992-02-03 00:00:00 | 18209179577 | NULL | 4 |
| 11 | 夏雪 | 女 | 1993-02-03 00:00:00 | 18209876579 | NULL | 9 |
| 12 | 赵敏 | 女 | 1992-02-03 00:00:00 | 18209179577 | NULL | 1 |
| 14 | 杨紫 | 女 | 1993-03-05 00:00:00 | 1352342232 | NULL | 8 |
| 15 | 刘诗诗 | 女 | 1987-01-01 00:00:00 | 12345678911 | NULL | NULL |
+----+------------+------+---------------------+-------------+-------+--------------+
扩充小知识
#\G可以以更美观的方式展示数据(某些程度下)
#\g和;的作用是一样的,不会改变数据的显示方式
select * from beauty\G;
\G的显示效果
*************************** 1. row ***************************
id: 1
name: 柳岩
sex: 女
borndate: 1988-02-03 00:00:00
phone: 18209876577
photo: NULL
boyfriend_id: 8
*************************** 2. row ***************************
id: 2
name: 苍老师
sex: 女
borndate: 1987-12-30 00:00:00
phone: 18219876577
photo: NULL
boyfriend_id: 9
*************************** 3. row ***************************
id: 3
name: Angelababy
sex: 女
borndate: 1989-02-03 00:00:00
phone: 18209876567
photo: NULL
boyfriend_id: 3
*************************** 4. row ***************************
id: 4
name: 热巴
sex: 女
borndate: 1993-02-03 00:00:00
phone: 18209876579
photo: NULL
boyfriend_id: 2
*************************** 5. row ***************************
id: 5
name: 周冬雨
sex: 女
borndate: 1992-02-03 00:00:00
phone: 18209179577
photo: NULL
boyfriend_id: 9
*************************** 6. row ***************************
id: 6
name: 周芷若
sex: 女
borndate: 1988-02-03 00:00:00
phone: 18209876577
photo: NULL
boyfriend_id: 1
*************************** 7. row ***************************
id: 7
name: 岳灵珊
sex: 女
borndate: 1987-12-30 00:00:00
phone: 18219876577
photo: NULL
boyfriend_id: 9
*************************** 8. row ***************************
id: 8
name: 小昭
sex: 女
borndate: 1989-02-03 00:00:00
phone: 18209876567
photo: NULL
boyfriend_id: 1
*************************** 9. row ***************************
id: 9
name: 双儿
sex: 女
borndate: 1993-02-03 00:00:00
phone: 18209876579
photo: NULL
boyfriend_id: 9
*************************** 10. row ***************************
id: 10
name: 王语嫣
sex: 女
borndate: 1992-02-03 00:00:00
phone: 18209179577
photo: NULL
boyfriend_id: 4
*************************** 11. row ***************************
id: 11
name: 夏雪
sex: 女
borndate: 1993-02-03 00:00:00
phone: 18209876579
photo: NULL
boyfriend_id: 9
*************************** 12. row ***************************
id: 12
name: 赵敏
sex: 女
borndate: 1992-02-03 00:00:00
phone: 18209179577
photo: NULL
boyfriend_id: 1
*************************** 13. row ***************************
id: 14
name: 杨紫
sex: 女
borndate: 1993-03-05 00:00:00
phone: 1352342232
photo: NULL
boyfriend_id: 8
*************************** 14. row ***************************
id: 15
name: 刘诗诗
sex: 女
borndate: 1987-01-01 00:00:00
phone: 12345678911
photo: NULL
boyfriend_id: NULL
寄语
每天进步一点点,积少成多,超越过去的自己