postgresql高级应用之合并单元格的思路详解（paste过去分词）奔走相告

文章摘要

这篇文章记录了不同商品及其分类的信息，涉及商品名称、价格、所属类别和子类别。具体包括洗发露、香皂、薯条、方便面、辣条、iPhone X、手表、电视、洗衣机、围巾、鞋子、作业本、铅笔、水杯、毛巾、绘图笔、汽水等商品。这些数据可能源自市场调查或电子商务平台的记录。文章通过插入语句展示了商品的详细信息，分类涵盖了食品、洗护、零食、小电器、大电器、服装配饰、文具、文具用品等多个领域，价格范围从3.5元到9600元不等。这些数据可以用于分析商品分类、价格走势或市场趋势。

INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0015’, ‘洗发露’, ’36’, ‘洗护’, ‘日用品’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0008’, ‘香皂’, ‘17.5’, ‘洗护’, ‘日用品’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0007’, ‘薯条’, ‘7.5’, ‘垃圾食品’, ‘零食’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0009’, ‘方便面’, ‘3.5’, ‘垃圾食品’, ‘零食’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0004’, ‘辣条’, ‘5.6’, ‘垃圾食品’, ‘零食’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0006’, ‘iPhone X’, ‘9600’, ‘小电器’, ‘电器’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0003’, ‘手表’, ‘1237.55’, ‘小电器’, ‘电器’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0012’, ‘电视’, ‘3299’, ‘大电器’, ‘电器’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0016’, ‘洗衣机’, ‘4999’, ‘大电器’, ‘电器’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0013’, ‘围巾’, ’93’, ‘配饰’, ‘服装配饰’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0017’, ‘特步凉鞋’, ‘499’, ‘鞋子’, ‘服装配饰’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0001’, ‘NIKE新款鞋’, ‘900’, ‘鞋子’, ‘服装配饰’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0002’, ‘外套’, ‘110.9’, ‘上衣’, ‘服装配饰’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0014’, ‘作业本’, ‘1’, ‘纸张’, ‘文具’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0005’, ‘铅笔’, ‘7’, ‘笔’, ‘文具’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0010’, ‘水杯’, ’27’, ‘餐饮’, ‘日用品’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0011’, ‘毛巾’, ’15’, ‘洗护’, ‘日用品’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0018’, ‘绘图笔’, ’15’, ‘笔’, ‘文具’);
INSERT INTO “report2″(“id”, “name”, “price”, “level2”, “level1”) VALUES (‘0019’, ‘汽水’, ‘3.5’, ‘其它’, ‘零食’);