MySQL数据库之MySQL的binary类型操作
本⽂主要向⼤家介绍了MySQL数据库之MySQL的binary类型操作，通过具体的内容向⼤家展现，希望对⼤家学习MySQL数据库有所帮助。
⽰例数据表：
CREATE TABLE test_bin (
bin_id BINARY(16) NOT NULL
) Engine=InnoDB;
插⼊数据(内容是⼀个32位的UUID字符串值)：
INSERT INTO test_bin(bin_id) VALUES(UNHEX(‘FA34E10293CB42848573A4E39937F479‘));
INSERT INTO test_bin(bin_id) VALUES(UNHEX(?));
或
INSERT INTO test_bin(bin_id) VALUES(x‘FA34E10293CB42848573A4E39937F479‘);
查询数据：
SELECT HEX(bin_id) AS bin_id FROM test_bin;
SELECT HEX(bin_id) AS bin_id FROM test_bin WHERE bin_id = UNHEX(‘FA34E10293CB42848573A4E39937F479‘);
SELECT HEX(bin_id) AS bin_id FROM test_bin WHERE bin_id = UNHEX(?);
SELECT HEX(bin_id) AS bin_id FROM test_bin WHERE bin_id = x‘FA34E10293CB42848573A4E39937F479‘;
查询结果：
bin_id
--------------------------
FA34E10293CB42848573A4E39937F479
mysql下载32位备注：使⽤MySQL内置的 UUID() 创建⼀个函数返回 BINARY（16）类型的UUID值
CREATE FUNCTION uu_id() RETURNS binary(16) RETURN UNHEX(REPLACE(UUID(),‘-‘,‘‘));
或
CREATE FUNCTION uu_id() RETURNS binary(16) RETURN UNHEX(REVERSE(REPLACE(UUID(),‘-‘,‘‘)));
使⽤：
INSERT INTO test_bin(bin_id) VALUES(uu_id());
范例1：
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
try {
conn = Connection(map);
String sql = "select HEX(RECID) AS recid,STDNAME AS stdname ,HEX(RESID) AS  resid  from jyyt";
stat = ateStatement();
rs = uteQuery(sql);
while (rs.next()) {
String recid = rs.getString("recid");
String staname = rs.getString("stdname");
String resid = rs.getString("resid");
System.out.println(recid + "---" + staname + "---" + resid);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
JDBCUtils.closeConnection(conn, stat, rs);
}
范例2：
SELECT
y.UNITID AS unitid,
y.UNITNAME AS unitName,
y.WARNINGTYPE AS warningType
FROM
GXJT_YJ AS y
LEFT JOIN md_org AS m ON m.RECID = y.UNITID
LEFT JOIN PMS_COMPANY_INFO AS p ON m.RECID = p.UNITID WHERE
HEX(m.parents) LIKE '%66F7B47C80000101D5E8ABF15CD9DA73%' AND y.WARNINGTYPE = 'REGISTRATION_DIFFERENT'
未使⽤HEX()函数：
使⽤HEX()函数：

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。