56,912
社区成员




C:\>debug edit3
-r
AX=0000 BX=0000 CX=0008 DX=0000 SP=FFEE BP=0000 SI=0000 DI=0000
DS=13C9 ES=13C9 SS=13C9 CS=13C9 IP=0100 NV UP EI PL NZ NA PO NC
13C9:0100 3132 XOR [BP+SI],SI SS:0000=20CD
-d
13C9:0100 31 32 33 34 35 36 37 38-00 00 00 00 00 00 00 00 12345678........
13C9:0110 00 00 00 00 00 00 00 00-00 00 00 00 34 00 B8 13 ............4...
13C9:0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 ................
13C9:0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 ................
13C9:0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 ................
13C9:0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 ................
13C9:0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 ................
13C9:0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 ................
-
mysql> desc tx;
+-------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| b1 | mediumblob | YES | | NULL | |
+-------+------------+------+-----+---------+-------+
2 rows in set (0.06 sec)
mysql>
mysql> update tx
-> set b1=LOAD_FILE('C:/edit3');
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
mysql> select hex(b1),length(b1) from tx;
+------------------+------------+
| hex(b1) | length(b1) |
+------------------+------------+
| 3132333435363738 | 8 |
+------------------+------------+
1 row in set (0.00 sec)
mysql>