mysql.sql
上传用户:zhihansy
上传日期:2014-12-04
资源大小:7241k
文件大小:3k
源码类别:

搜索引擎

开发平台:

Java

  1. CREATE DATABASE LUCENE;
  2. USE LUCENE;
  3. CREATE TABLE `product` (
  4. `product_id` int(11) NOT NULL auto_increment,
  5. `title` varchar(11) default NULL,
  6. `address` varchar(50) default NULL,
  7. `descr` text,
  8. `user_id` int(11) default NULL,
  9. `user_name` varchar(11) default NULL,
  10. `upload_time` date default NULL,
  11. `tag_name` varchar(11) default NULL,
  12. PRIMARY KEY (`product_id`)
  13. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
  14. insert into product values(1,"anycall三星","重庆沙坪坝区","三星手机,来自韩国的品牌",1,"申华锋",now(),"品牌手机");
  15. insert into product values(2,"nokia诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  16. insert into product values(3,"moto摩托罗拉","重庆沙坪坝区","三星手机,来自美国的品牌",1,"申华锋",now(),"品牌手机");
  17. insert into product values(4,"moto摩托罗拉","重庆沙坪坝区","三星手机,来自美国的品牌",1,"申华锋",now(),"品牌手机");
  18. insert into product values(5,"nokia诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  19. insert into product values(6,"java与模式","重庆渝北区","美籍华人阎宏的作品,对java设计模式有深刻的描述",2,"佐飞",now(),"计算机书籍");
  20. insert into product values(7,"j2ee核心模式","重庆渝北区","sun的官方书记,标准的j2ee设计模式讲述",2,"佐飞",now(),"计算机书籍");
  21. insert into product values(8,"java编程思想","重庆渝北区","本书赢得了全球程序员的广泛赞誉,即使是最晦涩的概念,在Bruce Eckel的文字亲和力和小而直接的编程示例面前也会化解于无形。",2,"佐飞",now(),"计算机书籍");
  22. insert into product values(9,"nokia520诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  23. insert into product values(11,"anycall303","重庆沙坪坝区","三星手机,来自韩国的品牌",1,"申华锋",now(),"品牌手机");
  24. insert into product values(12,"nokia520诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  25. insert into product values(13,"nokia520诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  26. insert into product values(14,"nokia520诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  27. insert into product values(15,"nokia520诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  28. insert into product values(16,"nokia520诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  29. insert into product values(25,"nokia32","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  30. insert into product values(26,"nokia32","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  31. insert into product values(27,"nokia33","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
  32. insert into product values(28,"3诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");