[file head]:
CREATE DATABASE LUCENE;

USE LUCENE;

CREATE TABLE `product` (
`product_id` int(11) NOT NULL auto_increment,
`title` varchar(11) default NULL,
`address` varchar(50) default NULL,
`descr` text,
`user_id` int(11) default NULL,
`user_name` varchar(11) default NULL,
`upload_time` date default NULL,
`tag_name` varchar(11) default NULL,
PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

insert into product values(1,"anycall三星","重庆沙坪坝区","三星手机，来自韩国的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(2,"nokia诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(3,"moto摩托罗拉","重庆沙坪坝区","三星手机，来自美国的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(4,"moto摩托罗拉","重庆沙坪坝区","三星手机，来自美国的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(5,"nokia诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",no
... ...

[file tail]:
... ...
","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(13,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(14,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(15,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(16,"nokia520诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(25,"nokia32","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(26,"nokia32","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(27,"nokia33","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
insert into product values(28,"3诺基亚","重庆沙坪坝区","三星手机，来自芬兰的品牌",1,"申华锋",now(),"品牌手机");