create database BlobTypeStudy;
use BlobTypeStudy;
create table BlobType( Bl Blob);
insert into BlobType values("巴巴托斯");
insert into BlobType values("摩拉克斯");
insert into blobType values("巴尔泽布");
insert into Blobtype values("布耶尔");
INSERT INTO Blobtype values("芙卡洛斯");
select * from Blobtype;
select * from Blobtype where bl="巴巴托斯";
mysql> insert into BlobType values("巴巴托斯");
mysql> INSERT INTO BlobType VALUES("摩拉克斯");
Query OK, 1 row affected (0.01 sec)
mysql> SELECT * FROM BlobType;
+----------------------------+
| BlobColumn |
+----------------------------+
| 0xE5B7B4E5B7B4E68998E696AF |
| 0xC4A6C0ADBFCBCBB9 |
+----------------------------+
2 rows in set (0.00 sec)
mysql> INSERT INTO BlobType VALUES("巴尔泽布");
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM BlobType;
+----------------------------+
| BlobColumn |
+----------------------------+
| 0xE5B7B4E5B7B4E68998E696AF |
| 0xC4A6C0ADBFCBCBB9 |
| 0xB0CDB6FBD4F3B2BC |
+----------------------------+
3 rows in set (0.00 sec)
mysql> INSERT INTO BlobType VALUES("布耶尔");
Query OK, 1 row affected (0.01 sec)
mysql> SELECT * FROM BlobType;
+----------------------------+
| BlobColumn |
+----------------------------+
| 0xE5B7B4E5B7B4E68998E696AF |
| 0xC4A6C0ADBFCBCBB9 |
| 0xB0CDB6FBD4F3B2BC |
| 0xB2BCD2AEB6FB |
+----------------------------+
4 rows in set (0.00 sec)
mysql> INSERT INTO BlobType VALUES("芙卡洛斯");
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM BlobType;
+----------------------------+
| BlobColumn |
+----------------------------+
| 0xE5B7B4E5B7B4E68998E696AF |
| 0xC4A6C0ADBFCBCBB9 |
| 0xB0CDB6FBD4F3B2BC |
| 0xB2BCD2AEB6FB |
| 0xDCBDBFA8C2E5CBB9 |
+----------------------------+
5 rows in set (0.00 sec)
Empty set (0.00 sec)