将十六进制值插入到mysql中 [英] inserting hex value into mysql
本文介绍了将十六进制值插入到mysql中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我也希望能够以十六进制形式检索它。
例如,
INSERT INTO table(hexTag)
VALUES(HEX(0x41));
如果我这样做,我希望它在表格中放入'A'$ b $对于那个特殊的用例,你可以直接插入十六进制值,它会被解释为一个字符串,或者使用HEX()来输入和UNHEX ()来输出
mysql> create table hexTable(pseudoHex varchar(50));
Query OK,0 rows affected(0.01 sec)
mysql> insert into hexTable values(0x41);
Query OK,1 row affected(0.00 sec)
mysql> select * from hexTable;
+ ----------- +
| pseudoHex |
+ ----------- +
| A |
+ ----------- +
1行设置(0.00秒)
mysql>从hexTable中选择HEX(pseudoHex)
+ ---------------- +
| HEX(pseudoHex)|
+ ---------------- +
| 41 |
+ ---------------- +
1行设置(0.00秒)
mysql> delete from hexTable;
Query OK,1 row affected(0.00 sec)
mysql> insert into hexTable values(HEX('A'));
Query OK,1 row affected(0.00 sec)
mysql>从hexTable中选择UNHEX(pseudoHex)
+ ------------------ +
| UNHEX(pseudoHex)|
+ ------------------ +
| A |
+ ------------------ +
1行设置(0.00秒)
mysql> select * from hexTable ;
+ ----------- +
| pseudoHex |
+ ----------- +
| 41 |
+ ----------- +
1行(0.00秒)
Can there any way to insert a hex value into MYSQL? I also want to be able to retreive it in hex form.
For example, something like: INSERT INTO table ( hexTag ) VALUES ( HEX(0x41) );
And if I do this, I want it to put an 'A' into the table
解决方案
For that particular use case, you can either insert the hex value directly and it will be interpreted as a string, or use HEX() to input and UNHEX() to output
mysql> create table hexTable(pseudoHex varchar(50)); Query OK, 0 rows affected (0.01 sec) mysql> insert into hexTable values (0x41); Query OK, 1 row affected (0.00 sec) mysql> select * from hexTable; +-----------+ | pseudoHex | +-----------+ | A | +-----------+ 1 row in set (0.00 sec) mysql> select HEX(pseudoHex) from hexTable; +----------------+ | HEX(pseudoHex) | +----------------+ | 41 | +----------------+ 1 row in set (0.00 sec) mysql> delete from hexTable; Query OK, 1 row affected (0.00 sec) mysql> insert into hexTable values (HEX('A')); Query OK, 1 row affected (0.00 sec) mysql> select UNHEX(pseudoHex) from hexTable; +------------------+ | UNHEX(pseudoHex) | +------------------+ | A | +------------------+ 1 row in set (0.00 sec) mysql> select * from hexTable; +-----------+ | pseudoHex | +-----------+ | 41 | +-----------+ 1 row in set (0.00 sec)
这篇关于将十六进制值插入到mysql中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文