我想从C盘的IMAGE文件夹下将3个照片(1.jpg(27k),2.jpg(70k),3.jpg(82k),)载入到表images中该如何操作呢?
建表:
mysql> create table images(
-> PicNum int NOT NULL AUTO_INCREMENT PRIMARY KEY, Image BLOB);
Query OK, 0 rows affected (0.03 sec)导入图像出错:
mysql> LOAD DATA INFILE 'C:/IMAGE'
-> REPLACE
-> INTO TABLE IMAGES
-> FIELDS TERMINATED BY ',' LINES TERMINATED BY'\r\n';
ERROR 29 (HY000): File 'C:\IMAGE' not found (Errcode: 13)
mysql> LOAD DATA INFILE 'C:/IMAGE.JPG'
-> REPLACE
-> INTO TABLE IMAGES
-> FIELDS TERMINATED BY ',' LINES TERMINATED BY'\r\n';
ERROR 1366 (HY000): Incorrect integer value: '?? for column 'PicNum' at row 1
mysql> LOAD DATA INFILE 'C:/IMAGE.txt'
-> REPLACE
-> INTO TABLE IMAGES
-> FIELDS TERMINATED BY ',' LINES TERMINATED BY'\r\n';
ERROR 29 (HY000): File 'C:\IMAGE.txt' not found (Errcode: 2)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货