- 论坛徽章:
- 27
|
本帖最后由 yifangyou 于 2011-03-26 22:22 编辑
例如,我把下面这张图片导入到mysql里
用navicat导入到下面的表:
也就是说你需要用代码实现从图片里把每个字节读出写到data字段就可以了- CREATE TABLE `image` (
- `id` int(10) NOT NULL AUTO_INCREMENT,
- `filename` varchar(255) NOT NULL,
- `data` blob NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- INSERT INTO `image` (`id`,`filename`,`data`) VALUES (NULL,'a.bmp',0x424DF600000000000000360000002800000008000000080000000100180000000000C000000000000000000000000000000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF000000000000000000000000FFFFFFFFFFFFFFFFFF000000FFFFFFFFFFFF000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF000000000000000000FFFFFFFFFFFFFFFFFFFFFFFF000000FFFFFFFFFFFF000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF);
复制代码 按照这种方式,无论是什么类型的文件都可以导入到数据库里。 |
|