ÁíÍ⻹ÓÐ1¸öÎÊÌâ: select data from table where id='XXX' DATAµÄֵΪBLOBÀàÐÍ select hex(data) from table where id='user1' µÃµ½user1µÄHEX DATAÖµ ÎÒÏëÈÃidΪuser2µÄdataÖµ µÈÓÚ user1µÄDATAÖµ ÈçºÎͨ¹ýת»»³ÉHEXµÄ·½Ê½À´ÐÞ¸ÄUSER2µÄÖµ? ÔõÑù ת»»³ÉHEXÖµµ¼³ö È»ºó½øÐÐÊý¾ÝÖеÄij×Ö·û È»ºóÔÙµ¼Èë? update table set data=hex(data) where ? SQL code: select data into @str from table where id='user1'; update table set data=@str where id='user2';