- 其实,无论是.tsv 还是.csv …都是通用的!
直接上代码!
//导入数据
LOAD DATA INFILE "E:/sql_related/UData/data_202107.tsv"
IGNORE INTO TABLE `202107`
CHARACTER SET gb2312
FIELDS TERMINATED BY "\t" ENCLOSED BY ""
LINES TERMINATED BY "\r\n";
但前提还是得先建表!
//创建表
CREATE TABLE `shop`(
`DATA_MONTH` DATE,
`USER_ID` varchar(12),
`SHOP_NAME` varchar(225),
`SHOP_SALES_VOLUME` int,
`SHOP_SALES_AMOUNT` decimal(10,5),
`MAIN_BUSINESS` varchar(50),
`BUSINESS_SCOPE` varchar(225),
`SHOP_PROVINCE` varchar(50),
`SHOP_CITY` varchar(50),
`SHOP_OPEN_DATE` DATE,
`ITEMDESC_SCORE` decimal(5,2),
`SERVICE_SCORE` decimal(5,2),
`DELIVERY_SCORE` decimal(5,2),
`COMPANY_PROVINCE` varchar(50),
`COMPANY_CITY` varchar(50),
`COMPANY_COUNTY` varchar(50),
`SHOP_DELIVERY_PROVINCE` varchar(50),
`SHOP_DELIVERY_CITY` varchar(50),
`SHOP_DELIVERY_COUNTY` varchar(50) );
偶然得知
peer pressure
可解释为“同侪压力”
心中顿觉疑惑!
何为“同侪压力”?
同侪指与自己在年龄、地位、兴趣等等方面相近的平辈,出自《左传·僖公二十三年》。同侪压力指朋友之间的影响力,出自《圣经》