请问下 这样的应该怎么显示出原来的字符

Question

INSERT INTO skk_ucenter_members VALUES ('22',0x48685fbaecb3bed2af,0x3633613334346136346331353563383966376436613033303765326431643631,0x3536343430313433304071712e636f6d,'','',0x3131302e3139312e3233322e35,'1348708126','0','0',0x653530646538,'');
我导入一个数据表 里面的数据是这样的 没见过 求指点

Answer 1

mysql> create table test7(id int,a varchar(100),b varchar(100),c varchar(100),d varchar(100),e varchar(100),f varchar(100),g varchar(100),h int,i int,j varchar(100),k int);
Query OK, 0 rows affected (0.03 sec)mysql> INSERT INTO test7 VALUES ('22',0x48685fbaecb3bed2af,0x3633613334346136346331353563383966376436613033303765326431643631,0x3536343430313433304071712e636f6d,'','',0x3131302e3139312e3233322e35,'1348708126','0','0',0x653530646538,'');
Query OK, 1 row affected, 1 warning (0.00 sec)mysql> select * from test7;
+------+--------------+----------------------------------+------------------+------+------+---------------+------------+------+------+--------+------+
| id   | a            | b                                | c                | d    | e    | f             | g          | h    | i    | j      | k    |
+------+--------------+----------------------------------+------------------+------+------+---------------+------------+------+------+--------+------+
|   22 | Hh_红尘爷    | 63a344a64c155c89f7d6a0307e2d1d61 | [email protected] |      |      | 110.191.232.5 | 1348708126 |    0 |    0 | e50de8 |    0 |
+------+--------------+----------------------------------+------------------+------+------+---------------+------------+------+------+--------+------+
1 row in set (0.01 sec)

Answer 2

谢谢啊 rucypli 还是想问您一下那个 LOAD的问题 我载入了4天了 原帖 http://bbs.csdn.net/topics/390543837?page=1#post-395267726