mysql.sql
上传用户:zhihansy
上传日期:2014-12-04
资源大小:7241k
文件大小:3k
- 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,"申华锋",now(),"品牌手机");
- insert into product values(6,"java与模式","重庆渝北区","美籍华人阎宏的作品,对java设计模式有深刻的描述",2,"佐飞",now(),"计算机书籍");
- insert into product values(7,"j2ee核心模式","重庆渝北区","sun的官方书记,标准的j2ee设计模式讲述",2,"佐飞",now(),"计算机书籍");
- insert into product values(8,"java编程思想","重庆渝北区","本书赢得了全球程序员的广泛赞誉,即使是最晦涩的概念,在Bruce Eckel的文字亲和力和小而直接的编程示例面前也会化解于无形。",2,"佐飞",now(),"计算机书籍");
- insert into product values(9,"nokia520诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",1,"申华锋",now(),"品牌手机");
- insert into product values(11,"anycall303","重庆沙坪坝区","三星手机,来自韩国的品牌",1,"申华锋",now(),"品牌手机");
- insert into product values(12,"nokia520诺基亚","重庆沙坪坝区","三星手机,来自芬兰的品牌",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(),"品牌手机");