create table TAB_BOOKINFO(
id bigint
primary key auto_increment,
name varchar(20),
author varchar(20),
publisher varchar(20),
price double,
image varchar(30),
catelog bigint
references TAB_CATELOG(id)
);
insert into TAB_BOOKINFO(name,author,publisher,price,image,catelog)
values(
'精通Struts',
'孙卫琴',
'人民邮电',
39,
'product/zcover1.gif',
1);
MYSQL中是怎样插入图片的?
id bigint
primary key auto_increment,
name varchar(20),
author varchar(20),
publisher varchar(20),
price double,
image varchar(30),
catelog bigint
references TAB_CATELOG(id)
);
insert into TAB_BOOKINFO(name,author,publisher,price,image,catelog)
values(
'精通Struts',
'孙卫琴',
'人民邮电',
39,
'product/zcover1.gif',
1);
MYSQL中是怎样插入图片的?
http://www.google.com/search?hl=zh-CN&q=mysql++%E4%BF%9D%E5%AD%98%E5%9B%BE%E7%89%87&btnG=Google+%E6%90%9C%E7%B4%A2&lr=
用php或者jsp等脚本读取图片,把读出的图片数据流直接存储到这个字段中就OK了